a month ago
I needed to increase the volume size of my docker postgre, now I can no longer log in to n8n, I have this error below in postgre, how to solve it?
2025-09-09 17:58:33.440 UTC [36] WARNING: database "railway" has a collation version mismatch
2025-09-09 17:58:33.440 UTC [36] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2025-09-09 17:58:33.440 UTC [36] 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.
0 Replies
in theory this warning shouldn't prevent you to access or use the db, to fix it you should run (remember to do a backup):
REINDEX DATABASE your-db-name
ALTER DATABASE your-db-name REFRESH COLLATION VERSION;
more info here:
https://station.railway.com/questions/collation-version-issue-3ae12b79#31x8
not sure about increasing the size, I suppose you could do it form the railway UI clicking in the volume below postgres, then update the volume size but I never tried…for sure a bakcup is needed before updating the disk size
Status changed to Solved noahd • about 1 month ago