Re: pg_upgrade and wraparound

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