From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Drouvot, Bertrand <bdrouvot@amazon.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Noah Misch <noah@leadboat.com>
Cc: Jason Harvey <jason@reddit.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: pgsql-hackers@postgresql.org, "Tharakan, Robins" <tharar@amazon.com>
Subject: Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load
Date: Tue, 05 Jul 2022 12:59:42 -0400
Message-ID: <1973418.1657040382@sss.pgh.pa.us> (raw)
In-Reply-To: <20210727023904.GA19774@momjian.us>
References: <CALSof1GM6i21BLr8PsFiRYazakojvesdc+_MiR-L_V5NNkRuWg@mail.gmail.com>
<CAH2-Wz=9Cj8H0=GAiHducPETWf6ZXEzjk_pFkjPWnWH6hptpLA@mail.gmail.com>
<20190615183759.GB239428@rfd.leadboat.com>
<20210423234256.hwopuftipdmp3okf@alap3.anarazel.de>
<20210424002827.GO7256@telsasoft.com>
<20210424010005.fttcfskp3unr4jiu@alap3.anarazel.de>
<fe006d56-85f1-5f1e-98e7-05b53dff4f51@amazon.com>
<78bf65ea-517a-51ed-947b-9728a6ace513@amazon.com>
<20210727023904.GA19774@momjian.us>
Bruce Momjian <bruce@momjian.us> writes:
> This patch has been applied back to 9.6 and will appear in the next
> minor release.
I have just discovered that this patch broke pg_upgrade's ability
to upgrade from 8.4:
$ pg_upgrade -b ~/version84/bin -d ...
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
The source cluster lacks some required control information:
latest checkpoint oldestXID
Cannot continue without required control information, terminating
Failure, exiting
Sure enough, 8.4's pg_controldata doesn't print anything about
oldestXID, because that info wasn't there then.
Given the lack of field complaints, it's probably not worth trying
to do anything to restore that capability. But we really ought to
update pg_upgrade's code and docs in pre-v15 branches to say that
the minimum supported source version is 9.0.
regards, tom lane
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: pgsql-general@postgresql.org
Cc: tgl@sss.pgh.pa.us, bruce@momjian.us, bdrouvot@amazon.com, andres@anarazel.de, pryzby@telsasoft.com, noah@leadboat.com, jason@reddit.com, pg@bowt.ie, tharar@amazon.com
Subject: Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load
In-Reply-To: <1973418.1657040382@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox