Re: pg_dump / pg_restore version confusion

2020-07-29 Thread Adrian Klaver
On 7/29/20 3:53 AM, 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? The best th

Re: pg_dump / pg_restore version confusion

2020-07-29 Thread Bruce Momjian
On Wed, Jul 29, 2020 at 12:33:56PM +, Zwettler Markus (OIZ) wrote: > And I can also do this restore: > > > Would a pg_restore with a v12 client into a postgres v9.6 database work and > be officially supported? > Uh, good question. You should still use the version of pg_restore that you ar

Re: pg_dump / pg_restore version confusion

2020-07-29 Thread Bruce Momjian
On Wed, Jul 29, 2020 at 10:53:34AM +, 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