Re: AW: pg_dump / pg_restore version confusion

On 7/29/20 6:38 AM, Zwettler Markus (OIZ) wrote:
> 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?

That is one way of attempting it, though it is not supported. You could
also try pg_restore v12 on pg_dump file v9.6 to Postgres v9.6 database
as well. With the caveats that I quoted in my previous post. Ideally you
would have the supplier redo the dump of the database with a 9.6 version
of pg_dump.

>
>
>
>> -----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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com