On Wed, Oct 30, 2024 at 06:25:35PM -0400, Max Pyziur wrote: > > > 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. Yeah. > I also noticed that I could run this in batch ($: psql <somedatabase> < FileWithAListOfCommands.sql) > > Any caveats on these procedures? Nope. I think that should be just fine... 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
