Re: Database Recovery

"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