Well this should be fun ... "Beware of your next glibc upgrade"
postgresql.verite.pro/blog/2018/08/2
Conversation
We need ICU collations that are usable as DB/cluster default.
Behavior of glibc collations is explicitly allowed to change. There is no mechanism in place to detect incompatibility. *Every* glibc upgrade should be assumed unsafe.
What do you think about the idea of a system_collation_version_command GUC, and a set of shell scripts for common operating systems?
1
Meh. There is some versioning info in glibc, actually, but it uses a non-standard interface, and might not be any good. I'd rather deal with the problem once, comprehensively. We should be able to certify compatibility of on-disk format with easy-to-use tool.
2
Show replies