Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group