Re: [NOVICE] EDTERROR: invalid page header in block 3271 of relationbase/16395/16426

#1

Hi John,

I have no experience with postgresql on windows but I can ask you this,
which method did you use to install, the "one click installer" or the
pgInstaller?
On 06/06/2012 03:42 PM, John Ly wrote:

Quote:

Hi all,

The following problem is on PostgreSQL 8.4.in <http://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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [NOVICE] EDTERROR: invalid page header in block 3271 of relationbase/16395/16426

mailing.database.pgsql-novice mailing.database.pgsql-novice

Re: [NOVICE] EDTERROR: invalid page header in block 3271 of relationbase/16395/16426 - 06-09-2012 , 01:41 PM