Postgres Pro
Downloads
Home   >   mailing lists

Corrupt Index - Mailing list pgsql-general

From Jorel Casal
Subject Corrupt Index
Date
Msg-id CAL+HUv2HQgzt83f8bnnbe8xAUdrdUpb3736Yv2ouM-PCfzp-6w@mail.gmail.com
Whole thread Raw
Responses Re: Corrupt Index
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Restoring using PG_DUMP in PG12 results in
Next
From: Tom Lane
Date:
Subject: Re: Corrupt Index