postgres database mismatch

I'm getting this warning and some errors after a trying to update to 1.8, it not working, and then downgrading to 1.7 again. I'm self-hosting and wondering if anyone can tell me how to update this. db-1 | 2025-10-22 15:46:00.477 UTC [2484] WARNING: database "postgres" has a collation version mismatch db-1 | 2025-10-22 15:46:00.477 UTC [2484] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41. db-1 | 2025-10-22 15:46:00.477 UTC [2484] 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.
2 Replies
hilarex
hilarex2mo ago
You can easily fix this issue by connecting to the database and running REINDEX DATABASE CONCURRENTLY postgres; ALTER DATABASE postgres REFRESH COLLATION VERSION;
L0RDANGUS
L0RDANGUSOP2mo ago
Thank you for the help! that was a surprisingly easy fix.

Did you find this page helpful?