a month ago
Postgres DB
A custom interface into your database
Deployment Online
This service has an active deployment.
Required Variables
This service has all the necessary variables that this UI uses to connect to the database.
TCP Proxy
TCP Proxy is configured correctly for Postgres on port 5432.
Database Connection
We are unable to connect to the database over the public network.
Connection closed
LOG: "2025-10-22 03:55:58.913 UTC [39] WARNING: database "railway" has a collation version mismatch2025-10-22 03:55:58.913 UTC [39] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2025-10-22 03:55:58.913 UTC [39] 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."
5 Replies
a month 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!
a month ago
It's an API I have, just to save data in the database.
No error appears in the log, when I try to run the command "ALTER DATABASE railway REFRESH COLLATION VERSION" it displays the attached error.
Attachments
25 days ago
The platform is not supported? I need to access my bank, even if it is just to copy the information to migrate to another platform.
25 days ago
The predeploy command failing is very odd to me, mostly because Railway's postgres service doesn't come with predeploy commands. Are you trying to run ALTER DATABASE railway REFRESH COLLATION VERSION as a predeploy command?
If that is the case, you'll want to undo any changes you made to the service. You can run commands by enabling the raw SQL queries in the feature flags and then you'll be able to run SQL queries directly in The Database tab in the PostgreSQL service. Alternatively you'll want to use an external database query tool