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

Re: DB corruption.

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DB corruption.
Date: 2011-10-09 17:49:16
Message-ID: 4E91DE9C.60408@krogh.cc (view raw or flat)
Thread:
Lists: pgsql-admin
On 2011-10-09 17:41, Tom Lane wrote:
> Jesper Krogh<jesper(at)krogh(dot)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.

So it is "just" blocknumber * blocksize .. offset, blocksize of zeroes.. ?
Or is the math harder?

-- 
Jesper

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2011-10-09 20:21:56
Subject: Re: DB corruption.
Previous:From: Tom LaneDate: 2011-10-09 15:41:57
Subject: Re: DB corruption.

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