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.
> 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, 

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 )

kevin

Attachment: 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

Reply via email to