Re: Database corruption. - Mailing list pgsql-general

From Brusser, Michael
Subject Re: Database corruption.
Date
Msg-id DAF7A2046DD4A24F8F77B086F840BF1907FE8396@msx11am.matrixone.net
Whole thread Raw
In response to Re: Database corruption.  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database corruption.
Next
From: "Michael Schmidt"
Date:
Subject: Re: SQL textbook