Re: [BUGS] 9.3beta2: Failure to pg_upgrade - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [BUGS] 9.3beta2: Failure to pg_upgrade
Date
Msg-id 20130803011409.GA27796@alap2.anarazel.de
Whole thread Raw
In response to Re: [BUGS] 9.3beta2: Failure to pg_upgrade  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [BUGS] 9.3beta2: Failure to pg_upgrade
List pgsql-hackers
On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote:
> Alvaro Herrera escribió:
> 
> > As it turns out, I have a patched slru.c that adds a new function to
> > verify whether a page exists on disk.  I created this for the commit
> > timestamp module, for the BDR branch, but I think it's what we need
> > here.
> 
> Here's a patch that should fix the problem.  Jesse, if you're able to
> test it, please give it a run and let me know if it works for you.  I
> was able to upgrade an installation containing a problem that should
> reproduce yours.

Wouldn't it be easier to make pg_upgrade fudge pg_control to have a safe
NextMultiXactId/Offset using pg_resetxlog?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Extension Templates S03E11
Next
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] 9.3beta2: Failure to pg_upgrade