Re: postgresql-common: use latest version of pg_dump/restore - Mailing list pgsql-pkg-debian

From Justin Pryzby
Subject Re: postgresql-common: use latest version of pg_dump/restore
Date
Msg-id ZE7vUbjizhzyjX7y@telsasoft.com
Whole thread Raw
In response to Re: postgresql-common: use latest version of pg_dump/restore  (Christoph Berg <myon@debian.org>)
Responses Re: postgresql-common: use latest version of pg_dump/restore  (Christoph Berg <myon@debian.org>)
List pgsql-pkg-debian
On Sun, Apr 30, 2023 at 09:57:19PM +0200, Christoph Berg wrote:
> Re: Justin Pryzby
> > I added dump/restore to this list locally while updating a backup script
> 
> Hmm, I thought that would void the ability to restore to the same old
> version?
> 
> source server version <= pg_restore <= pg_dump <= target server

Maybe I'm misundertanding your diagram - did you mean this ?

> source server version <= pg_dump <= pg_restore <= target server

I think you're considering the issue where pg_dump support is dropped
for very old versions - that'd be something that's like ~10 years old.
For example if someone has a pg9.1 server, and then installs pg15
clients, which dropped support for v9.1.

Wouldn't that be handled here for pg_dump, the same as for psql ?

    if ($version and $version < 9.2) { # psql 15 only supports PG 9.2+

-- 
Justin



pgsql-pkg-debian by date:

Previous
From: Christoph Berg
Date:
Subject: Re: postgresql-common: use latest version of pg_dump/restore
Next
From: Juliana de los Ríos
Date:
Subject: ARM64 AND PGADMIN WITH POSTGRESQL