OpenCHAMI / deployment-recipes

Ochami deployment recipes
MIT License
8 stars 10 forks source link

Upgrade postgres to a supported version (16?) #48

Open alexlovelltroy opened 4 months ago

alexlovelltroy commented 4 months ago

Postgres 11 is no longer supported. We should be able to upgrade to Postgres 16 and get back on a supported platform.

https://github.com/OpenCHAMI/deployment-recipes/blob/45a743ec34cf46965b1c1d9c43122393d550ca56/quickstart/postgres.yml#L6

I tried to drop in the new postgres container, but something seems to have changed with the way permissions work because I the migration containers report permission errors on 16.

We need to figure out what has changed and update the script that manages users and databases for us: [multi-psql-db.sh)(quickstart/pg-init/multi-psql-db.sh)