> On 10/30/2024 12:40 PM EDT Kevin Fenzi <kevin@xxxxxxxxx> wrote: > > > 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. [...] > > 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 ) Thank you for this. This works. I assume that this should also be applied to any templateX databases? I did this on my backup/test box. I also noticed that I could run this in batch ($: psql <somedatabase> < FileWithAListOfCommands.sql) Any caveats on these procedures? Thank you again, MP > kevin > -- c -- _______________________________________________ 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
