Corrupt Index

Поиск
Список
Период
Сортировка
От Jorel Casal
Тема Corrupt Index
Дата
Msg-id CAL+HUv2HQgzt83f8bnnbe8xAUdrdUpb3736Yv2ouM-PCfzp-6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Corrupt Index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Hi All, has anyone experienced corrupted unique indexes?

During a Patroni leader switchover, we had a situation where a unique index stopped "working", the index did not have records
that were in fact in the table and the table had duplicate records which should have been prevented by said unique index.

Fixing the duplicate records and reindexing seems to have fixed the problems, but I would like to be aware of it next time.

Is there a way to test for index corruption? Anyone else had this issue before?

Thanks
-Jorel

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Restoring using PG_DUMP in PG12 results in
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Corrupt Index