Skip to navigation
The database was created using collation version 2.31, but the operating system provides version 2.36.
10.07.23
if you get this error: ```apacheconf 2023-07-10 09:27:05.240 UTC [1710] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36. 2023-07-10 09:27:05.240 UTC [1710] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. ``` try for each database the bellow 3 commands. here for databases postgres and template1: ```console ALTER DATABASE postgres REFRESH COLLATION VERSION; \c postgres REINDEX DATABASE postgres; ALTER DATABASE template1 REFRESH COLLATION VERSION; \c template1 REINDEX DATABASE template1; ```
https://dba.stackexchange.com/questions/324649/collation-version-mismatch
Reply
Anonymous
Information Epoch 1742188413
Worse is better.
Home
Notebook
Contact us