Re: BUG #2279: invalid page header in block 95 of newtrd

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...

""herianto"" <herianto2(at)yahoo(dot)com> wrote
>
> 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.
>

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