Date: Sun, 30 Apr 2023 17:44:33 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Christoph Berg <myon@debian.org>, pgsql-pkg-debian@postgresql.org
Subject: Re: postgresql-common: use latest version of pg_dump/restore
Message-ID: <ZE7vUbjizhzyjX7y@telsasoft.com>
References: <ZE51EGITODFxnZhS@telsasoft.com>
 <ZE7IH5xSwtZEJSXr@msg.df7cb.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <ZE7IH5xSwtZEJSXr@msg.df7cb.de>
Archived-At: 
 <https://www.postgresql.org/message-id/ZE7vUbjizhzyjX7y%40telsasoft.com>
Precedence: bulk

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