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