Alex Derbes <acd(at)brillig(dot)org> writes:
> deleting the indexes from the table did not help. Is there a tool or
> method that that I could use to simply skip the bad data and at least
> recover the good blocks?
Just zero out the broken page, eg with dd from /dev/zero. Note it
might be a good idea to shut down the postmaster while you do so,
else there could be a copy of that page in Postgres shared buffers,
which'd mask your attempted fix.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Alex Derbes||Date: 2004-02-26 17:22:01|
|Subject: Re: Corrpupt Data File |
|Previous:||From: ronen||Date: 2004-02-26 09:29:21|
|Subject: Can't do any operation with the Server.|