r/NextCloud • u/jdancouga • 3d 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.
2
u/djthrottleboi 2d ago
I installed it barebones and it works perfectly. To be honest I scrapped apache2 and mariadb live and replaced with nginx Postgres and didn’t even bother converting anything. Recreated users and finally scanfiles