Re: Detecting corrupted pages earlier - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: Detecting corrupted pages earlier
Date
Msg-id Pine.LNX.4.33.0303281620090.8522-100000@leary.csoft.net
Whole thread Raw
In response to Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On Fri, 28 Mar 2003, Tom Lane wrote:

> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > How about adding a new option to skip corrupted pages ?
>
> I have committed changes to implement checking for damaged page headers,
> along the lines of last month's discussion.  It includes a GUC variable
> to control the response as suggested by Hiroshi.

Is zeroing the pages the only / best option?  Hiroshi suggested skipping
the pages as I recall.  Is there any chance of recovering data from a
trashed page manually?  If so perhaps the GUC variable should allow three
options: error, zero, and skip.

Kris Jurka



pgsql-hackers by date:

Previous
From: "Jason M. Felice"
Date:
Subject: EXPLAIN ANALYZE in comparable units
Next
From: mlw
Date:
Subject: Re: PostgreSQL and SOAP, version 7.4/8.0