Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Detecting corrupted pages earlier
Дата
Msg-id 001101c2f99a$9d5db880$6500a8c0@fhp.internal
обсуждение исходный текст
Ответ на Re: Detecting corrupted pages earlier  (Kris Jurka <books@ejurka.com>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Detecting corrupted pages earlier
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Detecting corrupted pages earlier