4 months ago
DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
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.
7 Replies
4 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!
4 months ago
This solution is not working . Please support with other solution
4 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 • 4 months ago
4 months ago
I have the same error after restore a backup
3 months ago
Anyone got this fixed?
yusuf-ishaku
Anyone got this fixed?
3 months ago
No
3 months ago
Can you share some more details? What project is it? What are you trying to deploy?
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