Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade - DEV Community
A unique index that stops catching duplicates after an OS or base-image upgrade is usually a glibc collation change. Here is how to confirm and fix it.