Search Postgresql Archives

Re: Corrupt btree index includes rows that don't match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> One coincidence is that we started seeing the first symptoms of this
> around the same time as libicu was updated with a security patch.
> However, postgres hasn’t been restarted and doesn’t reference the
> new version in its process maps. Plus state groups are integers
> anyway. We also use the C locale, not ICU.
Sounds as if you are hit by locale changes:

https://wiki.postgresql.org/wiki/Locale_data_changes


I think you will need to upgrade to prevent future problems like that: 

Postgres 15 introduced some mechanisms to track and validate version discrepancies after an OS update. 

Postgres 17 added a "built-in" collation provider which is independent of glibc









[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux