Re: Detecting corrupted pages earlier

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Detecting corrupted pages earlier
Date: 2003-02-19 06:09:06
Message-ID: 8887.1045634946@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> Tom Lane wrote:
>> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
>>> Is there a way to make our way around the pages ?
>>
>> If the header is corrupt, I don't think so.

> What I asked is how to read all other sane pages.

Oh, I see. You can do "SELECT ... LIMIT n" to get the rows before the
broken page, but there's no way to get the ones after it. My proposal
won't make this worse, but it won't make it any better either. Do you
have an idea how to get the rows after the broken page?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dennis Björklund 2003-02-19 06:57:01 translation stats
Previous Message Hiroshi Inoue 2003-02-19 06:06:53 Re: Detecting corrupted pages earlier