On Wed, Oct 30, 2024 at 06:25:35PM -0400, Max Pyziur wrote: > > > On 10/30/2024 12:40 PM EDT Kevin Fenzi <ke...@scrye.com> 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
signature.asc
Description: PGP signature
-- _______________________________________________ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org 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@lists.fedoraproject.org Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
