u/K-Man-Red

I am running my Nextcloud in Docker and have a separate PGSQL14 Docker to run its DB.

I was just reading instructions on how to upgrade my db from PGSQL14 to 18 and TBH it seems like a pain in the ass with lots of Fail-Potential.

So I was wondering if I could just user the OCC db:convert-type command to do it from inside Nextcloud? (I Switched from MariaDB to PGSQL that way).

So install a "fresh" PGSQL18 container and then simply issue:

OCC db:convert-type pgsql <postgresuser> <PG18ContainerName> <NextcloudDB>

Anyone tried this?