| From: | Michael Harris <michael(dot)harris(at)ericsson(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success |
| Date: | 2009-11-10 02:20:02 |
| Message-ID: | B0F87A6BC671B249AD1C6F7DF8ACA86C28971B2E60@ESGSCCMS0001.eapac.ericsson.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, 10 November 2009 12:04 PM
To: Michael Harris
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Michael Harris <michael(dot)harris(at)ericsson(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-11-10 02:41:27 | Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success |
| Previous Message | Scott Marlowe | 2009-11-10 02:18:58 | Re: Newbie cannot create tablespace |