Re: Invalid page header in block - Mailing list pgsql-general

From Tom Lane
Subject Re: Invalid page header in block
Date
Msg-id 12860.1070379989@sss.pgh.pa.us
Whole thread Raw
In response to Invalid page header in block  ("Carmen Wai" <wai_carmen@hotmail.com>)
Responses Re: Invalid page header in block  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
"Carmen Wai" <wai_carmen@hotmail.com> writes:
> I encounter a problem in which I have inserted about 1.6 million record to a
> database table (using postgresql 7.3.4), when I vacuum or select * from the
> table, it gets error message: Invalid page header in block 314345 of table.
> At first, I think it is my hard-disk problem, so I install another new
> machine (with the same config) and try again. But my new machine gets the
> same error when I insert more than 1.6 million to the database table.

Oh?  Could we see the contents of that block as dumped with pg_filedump?
(You can get it from http://sources.redhat.com/rhdb/tools.html)

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PG_DUMP question
Next
From: Franco Bruno Borghesi
Date:
Subject: how many quotes?