New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Nextcloud - Postgresql bad collation version #328

Open

ibizaman opened this issue Oct 25, 2024 · 1 comment

Labels

bug

Owner

ibizaman commented Oct 25, 2024

Had this warning popup in CLI with the latest update:

WARNING:  database "nextcloud" has a collation version mismatch
DETAIL:  The database was created using collation version 2.39, but the operating system provides version 2.40.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE nextcloud REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

I followed https://dba.stackexchange.com/a/324652 and did:

$ sudo -u nextcloud psql -U nextcloud
nextcloud=> REINDEX DATABASE nextcloud;
REINDEX
nextcloud=> ALTER DATABASE nextcloud REFRESH COLLATION VERSION;
NOTICE:  changing version from 2.39 to 2.40
ALTER DATABASE

This should be automated or at least documented.

The text was updated successfully, but these errors were encountered:

ibizaman added the bug label

Owner Author

ibizaman commented Nov 26, 2024 •

edited

Loading

Had that with forgejo, authelia and vaultwarden too!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment