Re: invalid page header - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid page header
Date
Msg-id 15528.1143036747@sss.pgh.pa.us
Whole thread Raw
In response to Re: invalid page header  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: invalid page header
List pgsql-general
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> "Jo De Haes" <jo.de_nospam_haes@indicator.be> wrote
>> CETERROR:  XX001: invalid page header in block 22182 of relation
> "dunn_main"

> I suppose there is no system error happens during the period (like lost
> power). Can you attach the gdb at "b bufmgr.c:257" and print the content of
> "(PageHeader) bufBlock"?

Probably easier (especially if he's not using a debug-enabled build):
dump out the page from the disk file using pg_filedump, or even just
"dd | od -x".

            regards, tom lane

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: xml output
Next
From: Steven Brown
Date:
Subject: Re: Enforcing serial uniqueness?