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

From Tom Lane
Subject Re: Detecting corrupted pages earlier
Date
Msg-id 8887.1045634946@sss.pgh.pa.us
Whole thread Raw
In response to Re: Detecting corrupted pages earlier  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-hackers
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>> Hiroshi Inoue <Inoue@tpf.co.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


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Detecting corrupted pages earlier
Next
From: Dennis Björklund
Date:
Subject: translation stats