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.
regards, tom lane
