3 months ago
I am getting the error below in production (not staging). I see there is some documentation on how to fix it but I am not a DB admin and I'm afraid to break my production application. Can someone at Railway help me resolve this smoothly?
WARNING: database "railway" has a collation version mismatch DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE railway REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. WARNING: database "railway" has a collation version mismatch DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE railway REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. INFO:werkzeug:100.64.0.8 - - [09/Sep/2025 11:18:16] "GET /api/admin/cockpit/activity-trends?hours=24 HTTP/1.1" 200 -
2 Replies
3 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
3 months ago
Please try connecting to your database using a DB client such as TablePlus and run:
ALTER DATABASE railway REFRESH COLLATION VERSION;
REINDEX DATABASE railway;Status changed to Awaiting User Response Railway • 3 months ago
2 months ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • 2 months ago