WARNING: database "mydatabase" has a collation version mismatch

[iswangyk]

I am seeing a warning about a database collation version mismatch in my LibreChat setup. The logs display the following message:

WARNING: database "mydatabase" 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 mydatabase REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

It doesn't stop me from using LibreChat, just concern if I need to do something to make sure that it will be ok in the furture

[xcodebasex]

I had the same error after an update; it’s easy to fix.

First, connect to the container where the database is located. In my example: docker-compose exec vectordb bash.
Then connect to the database: psql -U myuser -d mydatabase (you can find this information in docker-compose.yml).
Update the collation information in the database: ALTER DATABASE mydatabase REFRESH COLLATION VERSION;
This solved the problem for me. It’s best to create a snapshot first so you can roll back LibreChat to its state prior to the database changes.