Hello, I have my Nextcloud instance installed and functioning (Truenas Apps version, Dragonfish 24.04.2).
The current version of PostgreSQL for my Nextcloud is 13.1.
When a run the comand su -s /bin/bash www-data -c ‘php occ maintenance:repair’ I got a warning saying, “CREATE OR REPLACE TRIGGER memories_fcu_trg”.
The only reference I found online indicates that I should upgrade to Postgresql 14.
Is it possible to upgrade the Postgresql version?
Thanks in advance for any insight
No the maintainer for the app has to push the update. If the maintainer pushed the update you’ll get a notification that an upate is available and then you can update the app.
Thanks,
Interesting, so the maintainer could push an update for the database alone independently of the Nextcloud upgrading cycle, right?
This may explain why the database used for Nextcloud is lagging in Truenas.
I understand that Nextcloud is complatible with posgresql 12 to 16
https://docs.nextcloud.com/server/latest/admin_manual/installation/system_requirements.html
As far as i know yes, but i’ve deployed nextcloud inside a jail via docker-compose and use mariadb not postgresql. That way i have full controll of the update process and can switch database versions as needed myself and dont have to rely on others to push updates.
Congratulations, I like your approach.
I am looking forward for the Docker Compose Implementation in Scale (electric eel) to migrate to a new instance using your approach