5 months ago
2026-01-28 17:44:59.891 UTC [20293] WARNING: database "railway" has a collation version mismatch
2026-01-28 17:44:59.891 UTC [20293] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2026-01-28 17:44:59.891 UTC [20293] 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.
Pinned Solution
5 months ago
Run the following SQL command:
REINDEX DATABASE railway;
ALTER DATABASE railway REFRESH COLLATION VERSION;You can do this either through the raw SQL query in Railway (by enabling the feature flag in your workspace settings, or you can install a database client such as Datagrip and run the query from there.
1 Replies
5 months ago
Run the following SQL command:
REINDEX DATABASE railway;
ALTER DATABASE railway REFRESH COLLATION VERSION;You can do this either through the raw SQL query in Railway (by enabling the feature flag in your workspace settings, or you can install a database client such as Datagrip and run the query from there.
Status changed to Solved 0x5b62656e5d • 3 months ago