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

Re: Corrpupt Data File

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Derbes <acd(at)brillig(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Corrpupt Data File
Date: 2004-02-26 14:00:17
Message-ID: 11655.1077804017@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Alex Derbes <acd(at)brillig(dot)org> writes:
> deleting the indexes from the table did not help.  Is there a tool or 
> method that that I could use to simply skip the bad data and at least 
> recover the good blocks?

Just zero out the broken page, eg with dd from /dev/zero.  Note it
might be a good idea to shut down the postmaster while you do so,
else there could be a copy of that page in Postgres shared buffers,
which'd mask your attempted fix.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Alex DerbesDate: 2004-02-26 17:22:01
Subject: Re: Corrpupt Data File
Previous:From: ronenDate: 2004-02-26 09:29:21
Subject: Can't do any operation with the Server.

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