Re: Database Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike C" <smith(dot)not(dot)western(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Recovery
Date: 2007-10-08 01:48:16
Message-ID: 26143.1191808096@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Mike C" <smith(dot)not(dot)western(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike C 2007-10-08 01:58:28 Re: Database Recovery
Previous Message Tom Lane 2007-10-08 01:42:53 Re: Warm/hot backup server question