REFRESH COLLATION VERSION postgres warning
andremaytorena
PROOP

a year 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.```

Hey guys, out of nowhere I started getting this warning in my server, was this something I caused? or does this just happen periodically?
Solved$10 Bounty

12 Replies


andremaytorena
PROOP

a year ago

Would this have an impact on the actual API? or just deployments?


andremaytorena
PROOP

a year ago

Today our server has been going down over and over again and we can't figure out why


a year 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;


a year ago

Although this is relatively safe, its always good to back up your data!


a year ago

Hey @Andre Maytorena did your problem ever get resolved?


andremaytorena
PROOP

a year ago

Hey completely forgot to answer


andremaytorena
PROOP

a year ago

Yeah ended up doing that


andremaytorena
PROOP

a year ago

and it worked great


andremaytorena
PROOP

a year ago

thank yo


Status changed to Solved noahd 11 months ago


a year ago

Of course!


a year ago

!s


Welcome!

Sign in to your Railway account to join the conversation.

Loading...