Re: Database corruption.

From: "Brusser, Michael" <Michael(dot)Brusser(at)matrixone(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database corruption.
Date: 2007-02-08 17:24:42
Message-ID: DAF7A2046DD4A24F8F77B086F840BF1907FE8396@msx11am.matrixone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>> Zeroing out the whole block containing it is the usual recipe.

Something like this worked for me in the past:

% dd bs=8k count=X < /dev/zero >> clog-file

I had to calculate X, because I usually had a situation with truncated
clog-file, and a failed attempt to read it from offset XYZ.
And I used pg_controldata to check on the block-size.

Mike.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-08 17:25:07 Re: Database corruption.
Previous Message Michael Guerin 2007-02-08 17:24:27 Re: Database corruption.