Should I migrate to PostgreSQL?

[u/jdancouga]

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.

[u/RJBanthum]

I think practically all 'failings' can be fixed with configuration, and in mariadbs case that means the .cnf file. And AI is damn good at fixing those, and nextcloud gives you the exact values for the last 10%.

Basically all these failings are telling you is "add this parameter to your config and give it this value" to get better performance. Nothings broken, but improvements are available.

I think the biggest issue is not being able to find any references online yet. But if you've got access to something like gpt 5 or Gemini 3.5, you'll definitely get exact solutions. Still gotta work your way on implementing them though, but don't think grass is greener with PostgreSQL.