Hi!
On 2025-09-18T00:38:45+0200, Gabriel Wicki wrote:
after reconfiguring and rebooting my system log suddenly (?) complains
--8<---------------cut here---------------start------------->8---
2025-09-18 00:33:24 localhost postgres[3013]: [6-1] 2025-09-17 22:33:24.334 GMT [3013]
WARNING: database "cuirass" has a collation version mismatch
2025-09-18 00:33:24 localhost postgres[3013]: [6-2] 2025-09-17 22:33:24.334 GMT
[3013] DETAIL: The database was created using collation version 2.39, but the
operating system provides version 2.41.
2025-09-18 00:33:24 localhost postgres[3013]: [6-3] 2025-09-17 22:33:24.334 GMT
[3013] HINT: Rebuild all objects in this database that use the default
collation and run ALTER DATABASE cuirass REFRESH COLLATION VERSION, or build
PostgreSQL with the right library version.
--8<---------------cut here---------------end--------------->8---
Disclaimer: I don't know PostgreSQL, but I run Cuirass and had this
problem myself.
The "cuirass" database seems to have been created on a system with glibc
2.39 but the currently running postgres is linked against glibc 2.49.
what does
Rebuild all objects in this database
means? and how i can achieve that?
I used the following for my own installation based on [0]:
--8<---------------cut here---------------start------------->8---
sudo -u cuirass -- psql
WARNING: database "cuirass" has a collation version mismatch
DETAIL: The database was created using collation version 2.39, but the
operating system provides version 2.41.
HINT: Rebuild all objects in this database that use the default collation and
run ALTER DATABASE cuirass REFRESH COLLATION VERSION, or build PostgreSQL with
the right library version.
psql (15.8)
Type "help" for help.
cuirass=> REINDEX DATABASE cuirass;
REINDEX
cuirass=> ALTER DATABASE cuirass REFRESH COLLATION VERSION;
NOTICE: changing version from 2.39 to 2.41
ALTER DATABASE
cuirass=>
\q
--8<---------------cut here---------------end--------------->8---
vicvbcun
0:
https://dba.stackexchange.com/questions/324649/collation-version-mismatch/324652#324652
