Re: Detecting corrupted pages earlier

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Detecting corrupted pages earlier
Date: 2003-03-28 21:23:09
Message-ID: Pine.LNX.4.33.0303281620090.8522-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 28 Mar 2003, Tom Lane wrote:

> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-28 21:33:38 Re: Detecting corrupted pages earlier
Previous Message Jason M. Felice 2003-03-28 20:42:43 EXPLAIN ANALYZE in comparable units