3 months ago
2025-09-03 14:31:23.558 UTC [53] WARNING: database "railway" has a collation version mismatch
2025-09-03 14:31:23.558 UTC [53] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2025-09-03 14:31:23.558 UTC [53] 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.
Seeing this error over and over in the logs - this is the railway installed Postgres DB. Any idea how to resolve this?
Thanks!
3 Replies
3 months ago
Hey there! We've found the following might help you get unblocked faster:
🧵 PostgreSQL Collation Version Mismatch Error on Railway Template (PG 17) When Initializing Directus
If you find the answer from one of these, please let us know by solving the thread!
3 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 3 months ago
3 months ago
I've fixed it on my db running these queries (after a backup):
ALTER DATABASE your-db-name REFRESH COLLATION VERSION;
REINDEX DATABASE your-db-name
I'm not a db admin, my db was almost empty and it wasn't in prod so I didn't care to break it, I'm not sure if this is the right way but it might be an input for you to do your own research and proceed based on your finding (I do not take any responsibility)....in any case remember to do a backup
3 months ago
tengo un problema y no se ahora como conectarme am ibd me rechaza . que solucion hago a losiguiente
Volume of Postgres is 95% full in production
The volume of Postgres is using 95% of its current capacity. Grow the volume size, or reduce disk usage, to prevent service disruption from a full disk. You are only charged for the amount of storage used by your volumes.