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> -Markus > -----Ursprüngliche Nachricht----- > Von: Bruce Momjian <bruce@xxxxxxxxxx> > Gesendet: Mittwoch, 29. Juli 2020 13:49 > An: Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx> > Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx> > Betreff: Re: pg_dump / pg_restore version confusion > > On Wed, Jul 29, 2020 at 10:53:34AM +0000, Zwettler Markus (OIZ) wrote: > > Hi, > > > > > > > > An external supplier had a postgres v9.5 database which he dumped with > > a pg_dump v12 client in custom format using PgAdmin4. > > > > > > > > Would a pg_restore with a v12 client into a postgres v9.6 database > > work and be officially supported? > > Yes, you can always use a newer pg_dump on an older database, though the > reverse is not recommended. In fact, if you are upgrading to PG 12, it is > recommended to use pg_dump v12 to dump a Postgres database from an earlier > version. > > -- > Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us > EnterpriseDB https://enterprisedb.com > > The usefulness of a cup is in its emptiness, Bruce Lee
