Re: locate DB corruption

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: locate DB corruption
Дата
Msg-id a53fd1f1-cc41-32af-cb70-c95e196decc7@aklaver.com
обсуждение исходный текст
Ответ на Re: locate DB corruption  (Dave Peticolas <dave@krondo.com>)
Ответы Re: locate DB corruption
Список pgsql-general
On 09/01/2018 04:45 PM, Dave Peticolas wrote:

> Well restoring from a backup of the primary does seem to have fixed the 
> issue with the corrupt table.

Pretty sure it was not that the table was corrupt but that transaction 
information was missing from pg_clog.

In a previous post you mentioned you ran tar to do the snapshot of 
$PG_DATA.

Was there any error when tar ran the backup that caused you problems?


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Dave Peticolas
Дата:
Сообщение: Re: error in vacuum
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: error in vacuum