Hi all,
The following problem is on PostgreSQL 8.4.in Windows Server 2008
We use postgresql as our database and a system I am working on has the
following error in the Windows Event Viewer:
EDTERROR: invalid page header in block 3271 of relation base/16395/16426
My objectives are to find the cause of this and the solutions. And I have
the following questions:
1. Where are the postgresql logs? I am hoping to find which date the
corruption happened by reading through the log.
2. I did some research about this problem, and someone mentioned he used
pg_filedump and another tool (which I don't know the name) to 0 out the
corrupted data. Can someone point out where the compiled version (.exe) of
pg_filedump is? and what tools should I use to zero out the corrupted data?
Thank you,
AL