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, Max p...@brama.com mailto:p...@brama.com
-- _______________________________________________ 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
