| From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
|---|---|
| To: | Jesper Krogh <jesper(at)krogh(dot)cc> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: DB corruption. |
| Date: | 2011-10-09 08:49:28 |
| Message-ID: | CAGWYGjX80Ddk4-joUGWA3duAvmmvjkc_+X6YeiTzqYcgTQzWJA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)krogh(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-10-09 12:31:40 | Re: DB corruption. |
| Previous Message | fanlijing | 2011-10-09 08:00:53 | how to save a bytea value into a file? |