Re: DB corruption. - Mailing list pgsql-admin

From Lukasz Brodziak
Subject Re: DB corruption.
Date
Msg-id CAGWYGjX80Ddk4-joUGWA3duAvmmvjkc_+X6YeiTzqYcgTQzWJA@mail.gmail.com
Whole thread Raw
In response to DB corruption.  (Jesper Krogh <jesper@krogh.cc>)
Responses Re: DB corruption.
List pgsql-admin

Hi,
I would go with cluster on the relation with invalid page header and try to dump the db again. If you have an older dump of the db and data in corrupted table did not change since turnieju You may try to restore the table from it and run pg_dump again.
I don't know If one can ommit a page during dump You can exclude whole table.
Hope this helps You.
Regards
Luke

09-10-2011 08:49 użytkownik "Jesper Krogh" <jesper@krogh.cc> napisał:
Hi.

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?

Jesper

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Jesper Krogh
Date:
Subject: DB corruption.
Next
From: "Kevin Grittner"
Date:
Subject: Re: DB corruption.