Re: DB corruption.

On 2011-10-09 17:41, Tom Lane wrote:
> Jesper Krogh<jesper@krogh.cc>  writes:
>> I have got a corrupt db.. most likely due to an xfs bug..
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR:  invalid page header in block
>> 14174944 of relation base/16385/58318948
>> Can I somehow get pg_dump to "ignore" that block and dump everything else?
> The traditional solution is to zero out the bad block, eg using dd from
> /dev/zero.  It's easy to zero more than you intended, so practicing on a
> scratch copy of the table is recommended.
>
> But first you should check what kind of relation that is.  If it's an
> index, you could just REINDEX it instead.

So it is "just" blocknumber * blocksize .. offset, blocksize of zeroes.. ?
Or is the math harder?

--
Jesper