Re: pg_upgrade and wraparound - Mailing list pgsql-general

From Bruce Momjian
Subject Re: pg_upgrade and wraparound
Date
Msg-id 20210430193254.GA5370@momjian.us
Whole thread Raw
In response to pg_upgrade and wraparound  (Alexander Shutyaev <shutyaev@gmail.com>)
Responses Re: pg_upgrade and wraparound
List pgsql-general
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?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Skipping" BitmapHeapScan for simple counts
Next
From: Mike Beachy
Date:
Subject: Re: -1/0 virtualtransaction