From: | Marcelo Lacerda <marceloslacerda(at)gmail(dot)com> |
---|---|
To: | John Ly <ivianatwork(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: EDTERROR: invalid page header in block 3271 of relation base/16395/16426 |
Date: | 2012-06-09 18:41:48 |
Message-ID: | 4FD398EC.3020707@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | René Romero Benavides | 2012-06-12 02:16:40 | Re: Installing PostGIS 2.0 |
Previous Message | Marcelo Sena | 2012-06-09 18:21:34 | Re: Partitions are not excluded in stored procedures |