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
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To No-one
Architecture x86_64
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 3
Private No

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
Comment by Toolybird (Toolybird) - Friday, 10 February 2023, 21:01 GMT
postgresql 15.1-3 is now in the repo and it was built against glibc-2.37-2 so I assume this is fixed?
Comment by Richard PALO (risto3) - Friday, 10 February 2023, 22:15 GMT
? I believe glibc is still missing as a dependency.
Comment by Toolybird (Toolybird) - Friday, 10 February 2023, 22:20 GMT
I don't think a dep on glibc will magically fix it. @freswa, maybe you could add it to your mega-list of pkgs to be rebuilt at each major toolchain bump, but in particular for glibc?
Comment by Richard PALO (risto3) - Friday, 10 February 2023, 22:25 GMT
https://www.postgresql.org/docs/release/13.0/
>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
Comment by freswa (frederik) - Friday, 10 February 2023, 22:27 GMT
Added.

Loading...