Nextcloud: database "XXX" has a collation version mismatch

Apps and Virtualization
1

Hello,
i get following warning by mail from my truenas scale installation (25.04.2.1). The database is used by a nextcloud. it is the normal app provided by truenas. can someone help me, where and how i should execute the ALTER DATABASE command? I tried it alreade in the postgres container of the nextcloud app, but without success. it sais ALTER: not found

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

First, inside the postgres container, you have to login with the “right” username, that is the the postgres_user (not your user name). In my case it was “nextcloud”. Then log in with: psql -U -d nextcloud