Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load
Date
Msg-id CAH2-Wzm56aDZwhk99ka+TWMDDSv=KyEFt8uby9iww51w1_1Lpg@mail.gmail.com
Whole thread Raw
In response to Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On Tue, Jul 5, 2022 at 12:41 PM Peter Geoghegan <pg@bowt.ie> wrote:
> Actually, commit 74cf7d46 was where pg_resetxlog/pg_resetwal's -u
> argument was first added, for use by pg_upgrade. That commit is only
> about a year old, and was only backpatched to 9.6.

I just realized that this thread was where that work was first
discussed. That explains why it took a year to discover that we broke
8.4!

On further reflection I think that breaking pg_upgrade for 8.4 might
have been a good thing. The issue was fairly visible and obvious if
you actually ran into it, which is vastly preferable to what would
have happened before commit 74cf7d46.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: doc: BRIN indexes and autosummarize
Next
From: Noah Misch
Date:
Subject: Re: First draft of the PG 15 release notes