locate DB corruption

Поиск
Список
Период
Сортировка
От Dave Peticolas
Тема locate DB corruption
Дата
Msg-id CAPRbp04SbFObUL1m_geh3U57bAHE3gy0Q1Zuc0B_bCcUtsG5VQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: locate DB corruption  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hello, I'm running into the following error running a large query on a database restored from WAL replay:

could not access status of transaction 330569126
DETAIL: Could not open file "pg_clog/0C68": No such file or directory

Searches of this mailing list seem to indicate this means a database row has been corrupted. How would I go about locating the point of corruption in order to fix?

thanks,
dave

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: locate DB corruption