"Mike C" <smith.not.western@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
