Re: "invalid page header in block 597621 of relation..." error - Mailing list pgsql-general

From Tom Lane
Subject Re: "invalid page header in block 597621 of relation..." error
Date
Msg-id 26647.1132779359@sss.pgh.pa.us
Whole thread Raw
In response to "invalid page header in block 597621 of relation..." error  (Adam Witney <awitney@sgul.ac.uk>)
Responses Re: "invalid page header in block 597621 of relation..."error
List pgsql-general
Adam Witney <awitney@sgul.ac.uk> writes:
> bugasbase2=# SELECT count(*) from mba_data_base;
> ERROR:  invalid page header in block 597621 of relation "mba_data_base"

Sounds like a data corruption problem :-(.  Do you want to pull out that
page and see what's in it?  Something like

    dd bs=8k skip=73333 count=1 if=relationfile | od -x

where you need to use oid2name or something similar to determine which
file contains that relation, and then append ".4" because block 597621
would be in the fifth segment of the file.  (I got 73333 from
"select 597621 % 131072")

            regards, tom lane

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: "invalid page header in block 597621 of relation..." error
Next
From: Script Head
Date:
Subject: PL/pgSQL: how to round a number up?