16 days ago
i see this error in railway using n8n template:
2025-10-29 23:27:50.226 UTC [58272] WARNING: database "railway" has a collation version mismatch
2025-10-29 23:27:50.226 UTC [58272] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2025-10-29 23:27:50.226 UTC [58272] 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.
(postgress error) how can i fix this??
I didn't to anything, randomly just start failing! Weird!!! I need help, i have 100K daily users depending on this service!!!
HELP!!
3 Replies
16 days 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!
16 days ago
Have you run ALTER DATABASE railway REFRESH COLLATION VERSION as described in the error?
16 days ago
If you need help doing that:
Make a backup before continuing.
Install the Railway CLI
Right click the Postgres database
Copy the SSH command
Paste it into your terminal
Type
psqland press enterType
ALTER DATABASE railway REFRESH COLLATION VERSION;