From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Andrew Sullivan" <andrew(at)libertyrms(dot)info>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Detecting corrupted pages earlier |
Date: | 2003-04-03 04:36:36 |
Message-ID: | 001101c2f99a$9d5db880$6500a8c0@fhp.internal |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> What I'd really prefer to see is not a ZERO_DAMAGED_PAGES setting,
> but an explicit command to "DESTROY PAGE n OF TABLE foo". That would
> make you manually admit defeat for each individual page before it'd
> drop data. But I don't presently have time to implement such a command
> (any volunteers out there?). Also, I could see where try-to-dump, fail,
> DESTROY, try again, lather, rinse, repeat, could get pretty tedious on a
> badly damaged table.
I'm not volunteering, but this would be better:
ALTER TABLE foo ZERO [ PAGE n | BAD PAGES ];
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-03 04:46:55 | Re: Detecting corrupted pages earlier |
Previous Message | Alvaro Herrera | 2003-04-03 04:36:00 | Re: Detecting corrupted pages earlier |