Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-10-29 22:29:10
Subject: Re: trying to repair a bad header block
Previous:From: gherzigDate: 2008-10-29 21:59:29
Subject: trying to repair a bad header block

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group