Re: Invalid page header in block

Hello,

I also ran into this with 7.3.4. We had to reindex the database. It
recovered all but
two blocks. Once we figured out where those blocks were, we were able to
delete the
bad rows, dump the table, drop the table, restore the table.

We only lost those two rows and haven't had the problem since.

Sincerely,

Joshua D. Drake

Tom Lane wrote:

>"Carmen Wai" <wai_carmen(at)hotmail(dot)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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL