8 months ago
database "railway" has a collation version mismatch
2025-09-26 10:00:10.101 UTC [455] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
I tried running the query in db client
ALTERDATABASE railway REFRESHCOLLATIONVERSION;
REINDEXDATABASE railway;
but getting error : SQL Error [25001]: ERROR: REINDEX DATABASE cannot be executed within a pipeline
Error position:
3 Replies
8 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 WARNING: database "railway" has a collation version mismatch
- 🧵 n8n Service crashed after PostgreSQL automatic update - Collation version mismatch
- 🧵 Postgres collation version mismatch
- 🧵 Bug postgre
If you find the answer from one of these, please let us know by solving the thread!
8 months ago
solved
in db client connect the railway databse
then run
1. REINDEX DATABASE railway;
- ALTER DATABASE railway REFRESH COLLATION VERSION; and then redeploy the db service
Status changed to Awaiting User Response Railway • 8 months ago
Status changed to Solved echohack • 8 months ago