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 <br...@momjian.us> > Gesendet: Mittwoch, 29. Juli 2020 14:55 > An: Zwettler Markus (OIZ) <markus.zwett...@zuerich.ch> > Cc: pgsql-general <pgsql-general@lists.postgresql.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 <br...@momjian.us> https://momjian.us > EnterpriseDB https://enterprisedb.com > > The usefulness of a cup is in its emptiness, Bruce Lee
