Re: how to recover corrupt data

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: how to recover corrupt data
Дата
Msg-id 18918.1077061503@sss.pgh.pa.us
обсуждение исходный текст
Ответ на how to recover corrupt data  (Michael Adler <adler@pobox.com>)
Список pgsql-admin
Michael Adler <adler@pobox.com> writes:
> Is there any way to extract this (possibly intact) data?

It looks like you have one corrupted, perhaps partially zeroed, page
in your table.  There may be more, but the trace output you show only
has corrupted tuples on one page (11193).  You could try replacing that
page with zeroes, which will lose the rows on that page but allow you to
recover the rest of the data.  See the archives for discussion of
corruption recovery procedures (searching for references to pg_filedump
will probably lead you to the right threads).

            regards, tom lane

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

Предыдущее
От: "Benjamin Wragg"
Дата:
Сообщение: Re: Restoring pg_dump's made using COPY commands
Следующее
От: Tom Lane
Дата:
Сообщение: Re: large objects missing