search

truenas / apps

GNU Lesser General Public License v3.0
49 stars 13 forks source link

Update Nextcloud Postgresql to 16+ #342

Open Dremor opened 1 month ago

Dremor commented 1 month ago

Hi.

I'm a Truechart refugee with multiple Nextcloud instance to migrate, and I'm stuck because Truechart used Postgres 15 and TrueNAS is still using Postgres 13.

Unfortunately it is not possible to load a dump from en newer version on an older one, and as Truecharts nuked their repository, I'm unable to bring my app back to dump with an older PG version.

Would it be possible to update the database version, or at least make a Postgres stack available so I can import, then export with the right pgdump version ?

Best regards

stavros-k commented 1 month ago

A postgres app can be added once the migrations are done. I also wan to update postgres in all apps, but that needs some work to find a working/reliable way to automate this.

In the meantime, you can spin a docker container with older postgres version manually using docker run ... Export and then import.

Dremor commented 1 month ago

(Changed the Postgresql version as 1.15 seem to be PG 16 for some reason ^^")