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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq