Error on restore: could not create unique index

It’s likely a corrupt index. Someone will need to remove or fix the duplicate entries. How to Use amcheck to Check PostgreSQL Index Integrity (Corruption)might help. See also Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes).

1 Like