Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success - Mailing list pgsql-general

From Michael Harris
Subject Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Date
Msg-id B0F87A6BC671B249AD1C6F7DF8ACA86C28971B2E60@ESGSCCMS0001.eapac.ericsson.se
Whole thread Raw
In response to Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
answeringthis. 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@sss.pgh.pa.us]
Sent: Tuesday, 10 November 2009 12:04 PM
To: Michael Harris
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success


Michael Harris <michael.harris@ericsson.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.
Next
From: Alexandra Roy
Date:
Subject: Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed