FS#77445 - [postgresql] database "postgres" has a collation version mismatch
Attached to Project:
Arch Linux
Opened by Richard PALO (risto3) - Thursday, 09 February 2023, 13:45 GMT
Last edited by Toolybird (Toolybird) - Friday, 10 February 2023, 22:35 GMT
Opened by Richard PALO (risto3) - Thursday, 09 February 2023, 13:45 GMT
Last edited by Toolybird (Toolybird) - Friday, 10 February 2023, 22:35 GMT
|
Details
Description:
I get the following ``` $ psql postgres ATTENTION: database "postgres" has a collation version mismatch DÉTAIL : The database was created using collation version 2.36, but the operating system provides version 2.37. ASTUCE : Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. psql (15.1) Saisissez « help » pour l'aide. ``` Evidently I can do the alter database command, and I need to do it for my user databases, but I believe that the postgresql package should be rebuilt when its dependencies are updated. I believe glibc is missing as a dependency. Additional info: * package version(s) postgresql 15.1-1 glibc 2.37-2 * config and/or log files etc. * link to upstream bug report, if any Steps to reproduce: with above mentioned postgresql installed prior to 6 feb 2023, install update [2023-02-06T16:29:49+0100] [ALPM] upgraded glibc (2.36-7 -> 2.37-2) |
This task depends upon
Closed by Toolybird (Toolybird)
Friday, 10 February 2023, 22:35 GMT
Reason for closing: Fixed
Additional comments about closing: postgresql 15.1-3
Friday, 10 February 2023, 22:35 GMT
Reason for closing: Fixed
Additional comments about closing: postgresql 15.1-3
>Use the glibc version in some cases as a collation version identifier (Thomas Munro)
>If the glibc version changes, a warning will be issued about possible corruption of collation-dependent indexes