Re: AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Tom Lane
"Zwettler Markus (OIZ)" writes: > And I can also do this restore: > > Would a pg_restore with a v12 client into a postgres v9.6 database work and > be officially supported? > It might work, but it's not completely guaranteed. Sometimes a new pg_dump will use DDL syntax that doesn't exist in o

Re: AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Adrian Klaver
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

AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Zwettler Markus (OIZ)
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 =

AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Zwettler Markus (OIZ)
And I can also do this restore: Would a pg_restore with a v12 client into a postgres v9.6 database work and be officially supported? -Markus > -Ursprüngliche Nachricht- > Von: Bruce Momjian > Gesendet: Mittwoch, 29. Juli 2020 13:49 > An: Zwettler Markus (OIZ) > Cc: pgsql-general