Re: Database Recovery - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database Recovery
Date
Msg-id 26143.1191808096@sss.pgh.pa.us
Whole thread Raw
In response to Database Recovery  ("Mike C" <smith.not.western@gmail.com>)
Responses Re: Database Recovery  ("Mike C" <smith.not.western@gmail.com>)
List pgsql-admin
"Mike C" <smith.not.western@gmail.com> writes:
> I have a corrupt database. I copied the database directory offsite and
> restored from a backup. I'm now trying to recover data in the corrupt
> database added since the last backup. Any advice on how to approach
> this?

If you're lucky, REINDEX might solve your problems.  The messages you
showed are all about index corruption, which REINDEX can fix.  If you've
got corruption in the tables themselves then you might be screwed, but
try reindexing and see what happens ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Warm/hot backup server question
Next
From: "Mike C"
Date:
Subject: Re: Database Recovery