Re: pg_upgrade and wraparound

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Jan Wieck <jan(at)wi3ck(dot)info>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Alexander Shutyaev <shutyaev(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade and wraparound
Date: 2021-03-13 01:30:44
Message-ID: YEwVxHP5x7rOPwW5@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2021-03-13 13:28:37 How to recover data from 9.3 data directory
Previous Message Jan Wieck 2021-03-12 23:13:33 Re: pg_upgrade and wraparound