On Wed, Oct 30, 2024 at 11:52:25AM -0400, Max Pyziur wrote: > Greetings, > > I have three machines running Fedora, one just completed the update. Generally, no problems updating. > > But I noticed there was deprecation of postgresql, and when I went to review/work on one of my databases via cli I received the following message: > pyz@pegasus ~> psql commodities > WARNING: database "commodities" has a collation version mismatch > DETAIL: The database was created using collation version 2.39, but the operating system provides version 2.40. > HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE commodities REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. > psql (16.3) > Type "help" for help. > > commodities=# > > Generally in the past when there has been a major upgrade, then the procedure was to rebuild databases from backup. > > In this case, the issue seems to be a bit more nuanced. > > Any and all suggestions on how to proceed are welcome. Thank you, I hit this too, and just went and ran the 'ALTER DATABASE <dbname> REFRESH COLLATION VERSION' on each of my databases. My understanding is that it's the same postgres version between 40/41, but the 41 one was built against a newer glibc and this db's need to adjust to the new collation in it. Doing the alter does this. I also ran a reindexdb (but I am not sure this is entirely needed). ( reindexdb -a --concurrently -j 10 -v ) kevin
Attachment:
signature.asc
Description: PGP signature
-- _______________________________________________ users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
