"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