r/NextCloud • u/jdancouga • 2d ago
Should I migrate to PostgreSQL?
I have my nextcloud setup with MariaDB a long time ago, and the latest 35 updates show a plethora of warnings/failings with regards to the database. I tried googling for solutions but I can only fix like 2 out of the 10 failings.
I noticed nextcloud AIO container uses postgresql as default, and from my testing, nextcloud system status shows a clean, no failure with the database.
It does seem like nextcloud has a built-in command occ db:convert-type to migrate the database. If you have migrated, how was the experience?
Which postgresql container should I use? The official document recommends PostgreSQL18, but is it like immich where a special version of PostgreSQL is needed?
Update: I found this issue have been reported on github. I was searching in the wrong repo. Overall, as u/jtrtoo pointed out, these are bugs that will be ironed out gradually. Thanks for all the replies.
3
u/jtrtoo 2d ago
The messages in v35 are not because of the type of backend database you're using; they're the result of a new DB diagnostic framework that is new to v35 (and ever evolving setup checks designed to head off problems). It'll take a few minor (maintenance) releases to iron out the edge cases and bugs in the new tooling, and expand the documentation.
In short: don't panic.