Re: pg_upgrade and wraparound - Mailing list pgsql-general

From Jan Wieck
Subject Re: pg_upgrade and wraparound
Date
Msg-id 7bf19bf2-e6b7-01a7-1d96-f0607c728c49@wi3ck.info
Whole thread Raw
In response to Re: pg_upgrade and wraparound  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_upgrade and wraparound
List pgsql-general
On 4/30/21 3:32 PM, Bruce Momjian wrote:
> On Sat, Mar 13, 2021 at 08:43:54AM -0500, Jan Wieck wrote:
>> On 3/12/21 8:30 PM, Michael Paquier wrote:
>> > Hi Jan,
>> > 
>> > On Fri, Mar 12, 2021 at 06:13:33PM -0500, Jan Wieck wrote:
>> > > One of the things in my way is that when using pg_resetwal to put the
>> > > NextXID way into the future (to push the old cluster close to wraparound for
>> > > example), the postmaster won't start because it doesn't have the pg_xact
>> > > files for that around. Should pg_resetwal create the files in the gap
>> > > between the old NextXID and the new one?
>> > 
>> > I think that you should add this patch to the next commit fest to
>> > track it properly:
>> > https://commitfest.postgresql.org/33/
>> > --
>> > Michael
>> > 
>> 
>> Actually this is the wrong patch (this one is for PG-12, not for HEAD). Will
>> update later today.
>> 
>> But yes, putting it into the next commitfest after initial discussion is the
>> plan.
> 
> Uh, were either of these things done?
> 

Not yet, but I will enter it so that we can get it into 15 for sure.


Regards, Jan

-- 
Jan Wieck
Postgres User since 1994



pgsql-general by date:

Previous
From: Adrien Nayrat
Date:
Subject: Re: "invalid contrecord" error on replica
Next
From: Thomas Munro
Date:
Subject: Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64