database "railway" has a collation version mismatch
sherollswithspirit
HOBBYOP

a month 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.

$10 Bounty

1 Replies

0x5b62656e5d
FREETop 1% Contributor

a month 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.

Loading...