Re: invalid page header in block 29 of relation "pg_type" - Mailing list pgsql-admin

From Filip Krška
Subject Re: invalid page header in block 29 of relation "pg_type"
Date
Msg-id alpine.LFD.1.10.0806101037070.3363@fkrska.pha.comstar.cz
Whole thread Raw
In response to Re: invalid page header in block 29 of relation "pg_type"  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: "Tommy Cheng"
Date:
Subject: Re: turn off auto index for foreign key
Next
From: Simone Gadenz
Date:
Subject: Re: Connecting from xp to linux server