AW: pg_dump / pg_restore version confusion

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: AW: pg_dump / pg_restore version confusion
Date: 2020-07-29 13:38:52
Message-ID: 8b459360516e4a32aa0d675afae8357e@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I cannot use pg_restore v9.6 on a pg_dump v12 because otherwise: pg_restore: [archiver] unsupported version (1.14) in file header

The external supplier did PG v9.5 database + pg_dump v12.
I would have to do pg_restore v12 (as of pg_dump v12) into my PG v9.6.
The version chain would be PG v9.5 => pg_dump v12 => pg_restore v12 => PG v9.6.

That's why my question has been: would the whole chain work and is it supported?

> -----Ursprüngliche Nachricht-----
> Von: Bruce Momjian <bruce(at)momjian(dot)us>
> Gesendet: Mittwoch, 29. Juli 2020 14:55
> An: Zwettler Markus (OIZ) <Markus(dot)Zwettler(at)zuerich(dot)ch>
> Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
> Betreff: Re: pg_dump / pg_restore version confusion
>
> On Wed, Jul 29, 2020 at 12:33:56PM +0000, Zwettler Markus (OIZ) wrote:
> > And I can also do this restore:
> >
> > <quote>
> > Would a pg_restore with a v12 client into a postgres v9.6 database work and be
> officially supported?
> > </quote>
>
> Uh, good question. You should still use the version of pg_restore that you are
> loading _into_, not what you dumped from.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EnterpriseDB https://enterprisedb.com
>
> The usefulness of a cup is in its emptiness, Bruce Lee

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-29 13:44:14 Re: pg_dump / pg_restore version confusion
Previous Message Bruce Momjian 2020-07-29 12:54:32 Re: pg_dump / pg_restore version confusion