Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success

Поиск
Список
Период
Сортировка
От Michael Harris
Тема Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Дата
Msg-id B0F87A6BC671B249AD1C6F7DF8ACA86C28971B2E60@ESGSCCMS0001.eapac.ericsson.se
обсуждение исходный текст
Ответ на Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.
Следующее
От: Alexandra Roy
Дата:
Сообщение: Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed