Chris Purcell <chris(dot)purcell(dot)39(at)gmail(dot)com> writes:
> Given that we are where we are, what is the best advice? Can we
> recover the database, given that 99% of the data works? I can happily
> drop the entire contents of the "pagecache" table, as it is
> regenerated on the fly, if that will obviate the problem.
That will get you past the reported problem, but I wonder what other
corruption is lurking ... once you've managed to pg_dump you'd better
inspect the data very carefully.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: gerrit||Date: 2006-09-12 15:26:33|
|Subject: BUG #2623: query optimizer not using indexes with inheritance and joins|
|Previous:||From: Shelby Cain||Date: 2006-09-12 14:07:20|
|Subject: Re: BUG #2609: server crash at 182 connections still alive.|