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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Filip Krška <filip(dot)krska(at)comstar(dot)cz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: invalid page header in block 29 of relation "pg_type"
Date: 2008-06-09 18:21:28
Message-ID: 20080609182127.GC10034@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hays Steve - sthays 2008-06-09 20:08:32 Cannot Drop Schema
Previous Message Tom Lane 2008-06-09 15:26:16 Re: Connecting from xp to linux server