Re: pg_internal.init is hazardous to your health

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