The following bug has been logged online:

Bug reference: 2279
Logged by: herianto
Email address: herianto2 (AT) yahoo (DOT) com
PostgreSQL version: 8.1.0
Operating system: Windows XP
Description: invalid page header in block 95 of newtrd
Details:

Hi,


Every I will query select * from namaTable , I get Error invalid page
header. but if me use query select * from namaTable limit 1008. I get Query
is successfully.

Total rows of tables is 1009. while if me query select * from namaTable
limit 1009, I get error same. Then I try to add new record or delete last
record,again i get error invalid page header.

how the solution of because this matter have happened recuring. I have read
some web specially in postgres, most saying that the problem are hardware
but I have try in some computers and in the reality yield error the is
sameness. if it is true the problem of the hardware? and what hardware is
compatible...

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

""herianto"" <herianto2 (AT) yahoo (DOT) com> wrote
It looks like that record #1009 is in a broken data page. A workaround is to
copy the first 1008 records to another table by doing "insert into
new_namaTable select * from namaTable limit 1008" and enter #1009 again.
Then use the new_namaTable.

Not sure what caused this though. Is there any system crash while adding
this record?

Regards,
Qingqing



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings