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

From Alvaro Herrera
Subject Re: invalid page header in block 29 of relation "pg_type"
Date
Msg-id 20080609182127.GC10034@alvh.no-ip.org
Whole thread Raw
In response to Re: invalid page header in block 29 of relation "pg_type"  (Filip Krška <filip.krska@comstar.cz>)
Responses Re: invalid page header in block 29 of relation "pg_type"  (Filip Krška <filip.krska@comstar.cz>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Connecting from xp to linux server
Next
From: Simone Gadenz
Date:
Subject: Re: Connecting from xp to linux server