Re: AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Tom Lane
"Zwettler Markus (OIZ)" writes: > 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? > It might work, but it's not completely guaranteed. Sometimes a new pg_dump will use DDL syntax that doesn't exist in o

Re: AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Adrian Klaver
5 An: Zwettler Markus (OIZ) Cc: pgsql-general Betreff: Re: pg_dump / pg_restore version confusion 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 sup

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

AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Zwettler Markus (OIZ)
pgsql-general > Betreff: Re: pg_dump / pg_restore version confusion > > 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 &g

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

AW: pg_dump / pg_restore version confusion

2020-07-29 Thread Zwettler Markus (OIZ)
: pgsql-general > Betreff: Re: pg_dump / pg_restore version confusion > > 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 &g

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

pg_dump / pg_restore version confusion

2020-07-29 Thread Zwettler Markus (OIZ)
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? Thanks, Markus