Hi Tom, Postgres is 8.2.3. The owners of this database have now decided to rebuild it from scratch so please don't spend much more time on answering this. Although, I'd like to know how to proceed in cases like this in case it ever happens again. Regards // Mike -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Tuesday, 10 November 2009 12:04 PM To: Michael Harris Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success Michael Harris <michael.harris@xxxxxxxxxxxx> writes: > I have been asked to help recover a database that seems to have been corrupted after a power failure. What PG version is this exactly? > Also what does it mean by "Success" in the FATAL message? It's probably a read-past-EOF case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
