Re: Database corruption. - Mailing list pgsql-general

From Tom Lane
Subject Re: Database corruption.
Date
Msg-id 16348.1170953396@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database corruption.  (Michael Guerin <guerin@rentec.com>)
Responses Re: Database corruption.
Re: Database corruption.
List pgsql-general
Michael Guerin <guerin@rentec.com> writes:
> Ok, so I'm trying to track down the rows now (big table slow queries :(
> )  How does one zero out a corrupt row, plain delete?  I see references
> for creating the missing pg_clog file but I don't believe that's what
> you're suggesting..

Zeroing out the whole block containing it is the usual recipe.  I forget
the exact command but if you trawl the archives for mention of "dd" and
"/dev/zero" you'll probably find it.  Keep in mind you want to stop the
postmaster first, to ensure it doesn't have a copy of the bad block
cached in memory.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Guerin
Date:
Subject: Re: Database corruption.
Next
From: Bruce Momjian
Date:
Subject: Re: Error on table insert: attribute 13 has wrong type