Re: pg_internal.init is hazardous to your health - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: pg_internal.init is hazardous to your health
Date
Msg-id 1161986066.11568.88.camel@silverbirch.site
Whole thread Raw
In response to Re: pg_internal.init is hazardous to your health  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
On Wed, 2006-10-18 at 15:56 +0100, Simon Riggs wrote:
> On Tue, 2006-10-17 at 22:29 -0400, Tom Lane wrote:
> > The answer that ultimately emerged was that they'd been running a
> > nightly maintenance script that did REINDEX SYSTEM (among other things
> > I suppose).  The PITR base backup included pg_internal.init files that
> > were appropriate when it was taken, and the PITR recovery process did
> > nothing whatsoever to update 'em :-(.  So incoming backends picked up
> > init files with obsolete relfilenode values.
> 
> OK, I'm looking at this now for later discussion.

I've coded a patch and am just testing now.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [PATCHES] WAL logging freezing
Next
From: "Simon Riggs"
Date:
Subject: Re: [PATCHES] WAL logging freezing