Re: Detecting corrupted pages earlier
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: pgsql-hackers@postgreSQL.org
Date: 2003-02-19T06:09:06Z
Lists: 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