public inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin Pryzby <[email protected]>
To: Christoph Berg <[email protected]>
To: [email protected]
Subject: Re: postgresql-common: use latest version of pg_dump/restore
Date: Sun, 30 Apr 2023 17:44:33 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: postgresql-common: use latest version of pg_dump/restore
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox