| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pg_dump / pg_restore version confusion |
| Date: | 2020-07-29 11:49:25 |
| Message-ID: | 20200729114925.GA12059@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zwettler Markus (OIZ) | 2020-07-29 12:33:56 | AW: pg_dump / pg_restore version confusion |
| Previous Message | Zwettler Markus (OIZ) | 2020-07-29 10:53:34 | pg_dump / pg_restore version confusion |