Re: invalid page header in block 29 of relation "pg_type"

Поиск
Список
Период
Сортировка
От Filip Krška
Тема Re: invalid page header in block 29 of relation "pg_type"
Дата
Msg-id alpine.LFD.1.10.0806101037070.3363@fkrska.pha.comstar.cz
обсуждение исходный текст
Ответ на Re: invalid page header in block 29 of relation "pg_type"  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
It was CentOS release 3.8 and ext2 (I switched it to ext3 after the
disaster).

HW is HP Array P400, with HP DG146ABAB4 Disks.

Status of one of the disk switched from OK to predictive failure, I guess
the array didn't recognize the failure and didn't park it in time.

Filip

======================================

On Mon, 9 Jun 2008, Alvaro Herrera
wrote:

> Filip Krška wrote:
>> I hope, I've solved it.
>>
>> I found 512 damaged bytes on the 29th 8k page of the pg_type's datafile
>> ($PGDATA/base/16390/1247), it was overwritten by text from some log(?!).
>
> Ugh.  For the record, what operating system and filesystem are you
> using?  Oh, the underlying storage may be useful too.
>
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Tommy Cheng"
Дата:
Сообщение: Re: turn off auto index for foreign key
Следующее
От: Simone Gadenz
Дата:
Сообщение: Re: Connecting from xp to linux server