Postgres Pro
Downloads
Home   >   mailing lists

Re: trying to repair a bad header block - Mailing list pgsql-sql

From Tom Lane
Subject Re: trying to repair a bad header block
Date
Msg-id 27353.1225319018@sss.pgh.pa.us
Whole thread Raw
In response to trying to repair a bad header block  (gherzig@fmed.uba.ar)
Responses Re: trying to repair a bad header block
List pgsql-sql
Tree view 
gherzig@fmed.uba.ar writes:
> There is a way to 'correct' or blank the values somehow? I guess im going
> to lose some data, iisnt...

If you can tolerate losing the data on that page, just zero out the
entire 8K page.  dd from /dev/zero is the usual tool.
        regards, tom lane

pgsql-sql by date:

Previous
From: gherzig@fmed.uba.ar
Date:
Subject: trying to repair a bad header block
Next
From: "Scott Marlowe"
Date:
Subject: Re: trying to repair a bad header block