Re: trying to repair a bad header block

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gherzig(at)fmed(dot)uba(dot)ar
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: trying to repair a bad header block
Date: 2008-10-29 22:23:38
Message-ID: 27353.1225319018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

gherzig(at)fmed(dot)uba(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2008-10-29 22:29:10 Re: trying to repair a bad header block
Previous Message gherzig 2008-10-29 21:59:29 trying to repair a bad header block