Re: pg_internal.init is hazardous to your health

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: pg_internal.init is hazardous to your health
Date: 2006-10-27 21:54:26
Message-ID: 1161986066.11568.88.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-10-27 22:03:17 Re: [HACKERS] WAL logging freezing
Previous Message Tom Lane 2006-10-27 21:23:38 Re: [HACKERS] WAL logging freezing