Thanks! That helps a lot.
In my case it was Postgres 13 and 16:
pg_lsclustersVer Cluster Port Status Owner Data directory Log file13 main 5432 online postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log16 main 5433 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
Sad that the migration doesn’t do the job, i tried:
yunohost tools migrations run postgresql_13_to_15 --force-rerun
But it just ran into an error. Think it’s not so robust to handle my mixed case.
I doesn’t used your idea with manually SQL dump/restore. What i have done was:
- Backup of all Apps that still used postgres 13
- Deinstall these apps
- Stop the v13 cluster
- changed the port of v16
- deinstalled v13
- restore the Apps
After this, all apps used v16 and i can apply the missing app updates.
EDIT: One missing part seems to change the postgres version in /etc/postgresql-common/user_clusters