Greetings,
I have three machines running Fedora, one just completed the update. Generally, no problems updating.
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.
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,
Any and all suggestions on how to proceed are welcome. Thank you,
Max
-- _______________________________________________ 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
