2 months ago
WARNING: database "railway" has a collation version mismatch 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.
Hey guys, out of nowhere I started getting this warning in my server, was this something I caused? or does this just happen periodically?
0 Replies
Today our server has been going down over and over again and we can't figure out why
2 months ago
Hey there! The coalition version has nothing to do with that incident.
Its just a warning and doesnt have any effect on your data.
If you do however want to fix it please back up your data, ssh into the postgres service, and run ALTER DATABASE railway REFRESH COLLATION VERSION;
2 months ago
Although this is relatively safe, its always good to back up your data!
2 months ago
Hey @Andre Maytorena did your problem ever get resolved?
Status changed to Solved noahd • 2 months ago
2 months ago
Of course!
2 months ago
!s