Sample Header Ad - 728x90

postgres collation mismatch

0 votes
1 answer
624 views
I have pgserver running postgres 17, OS untuntu 24. The collation version is 2.40. My client side is Rocky linux 8: hlsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: Rocky Description: Rocky Linux release 8.10 (Green Obsidian) Release: 8.10 Codename: GreenObsidian hepsql --version psql (PostgreSQL) 17.0 After I login to the server from my client machine (pgclient) I got warning. WARNING: database "aurum" has a collation version mismatch DETAIL: The database was created using collation version 2.40, but the operating system provides version 2.39. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE aurum REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. psql (17.0) I don't want to rebuild my server to 2.39. To upgrade my collation to 2.40, should I recompile a new client program using the latest GCC library?
Asked by Kemin Zhou (219 rep)
Oct 21, 2024, 09:10 PM
Last activity: Feb 25, 2025, 02:00 AM