Re: How can I find a broken row in a table

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How can I find a broken row in a table
Дата
Msg-id 4BC82D5502000025000309D8@gw.wicourts.gov
обсуждение исходный текст
Ответ на How can I find a broken row in a table  (Khangelani Gama <Khangelani.Gama@ucs-software.co.za>)
Список pgsql-admin
Khangelani Gama <Khangelani.Gama@ucs-software.co.za> wrote:

> there is a table that has a broken row, but now I don't know which
> one is broken. the table has about 20974 pages.

If there are any indexes on the table which haven't been corrupted,
you might try selecting ranges of rows using one of them, capturing
the undamaged data into a new table.  By subdividing damaged ranges
you can do a sort of "binary search" for the bad rows while
recovering the good ones.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How can I find a broken row in a table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"