AW: pg_dump / pg_restore version confusion

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