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
