DB corruption.

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: DB corruption.
Date: 2011-10-09 06:40:08
Message-ID: 4E9141C8.2020805@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message fanlijing 2011-10-09 08:00:53 how to save a bytea value into a file?
Previous Message Craig Ringer 2011-10-08 04:50:09 Re: password problems