Date: Wed, 8 Apr 2026 13:04:02 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>,
	pgsql-hackers@postgresql.org
Subject: Re: bump minimum supported version of psql and
 pg_{dump,dumpall,upgrade} to v10
Message-ID: <adaYkolh91sU7scE@nathan>
References: <adZ4j88Dq9r8y9_9@nathan>
 <3070727.1775665381@sss.pgh.pa.us>
 <3b5bd0ba-d9a0-4d0b-9b5d-674948ea7529@dunslane.net>
 <CADkLM=fyg1gDtq7AH7N1yazJfdMSdeY8=TYrfDaGqT8hRCgzRw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CADkLM=fyg1gDtq7AH7N1yazJfdMSdeY8=TYrfDaGqT8hRCgzRw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/adaYkolh91sU7scE%40nathan>
Precedence: bulk

On Wed, Apr 08, 2026 at 01:24:29PM -0400, Corey Huinker wrote:
> It would help if we provided some small documentation on how to do that. It
> could be as simple as a docbook table mapping various postgres versions to
> the highest version a) a live database can be pg_upgraded to and b) a
> dumpfile can be pg_restored to. But it could also include a script to
> re-dump an old dumpfile to a newer dump version. I'd be happy to take a
> swing at that if nobody else is interested.

I like these ideas.  IMHO this helps us be reasonably aggressive about
removing support for ancient versions while still providing a lifeboat when
folks using those ancient versions decide to upgrade.

-- 
nathan