7 months 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
7 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 Unable to access my n8n
- 🧵 Postgres collation version mismatch
- 🧵 n8n Service crashed after PostgreSQL automatic update - Collation version mismatch
If you find the answer from one of these, please let us know by solving the thread!
7 months ago
Have you run ALTER DATABASE railway REFRESH COLLATION VERSION as described in the error?
7 months 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 enter - Type
ALTER DATABASE railway REFRESH COLLATION VERSION;