Percona documents glibc locale changes breaking PostgreSQL clusters

Changes between glibc versions alter character string comparison, sorting, and functions, which can break PostgreSQL clusters in various ways beyond simple index corruption. The author outlines ten distinct failure areas—including unique and foreign keys, constraints, partitioned tables, and generated columns—alongside two behavioral changes that do not cause direct data corruption. Mitigating these issues requires careful assessment, reindexing, moving misplaced rows, revalidating constraints, and updating statistics or views. Open article →