Use newer Postgres

[dev-rke]

Hi,

as the postgresql/Dockerfile indicates, currently Postgres version 12 is used.
Is there any hard dependency on that?

As far as i found out, ckan does not have a strong version constraint on Postgres, so i'd propose to update to Postgres 16, as it is the latest stable container: https://hub.docker.com/_/postgres

[kowh-ai]

@dev-rke - Yes there is no hard constraint on v12 however we do try to align with the same version as CKAN set up on non-docker based environment. There will be a version upgrade soon and I think PostgreSQL v12 is EOL later this year

[dev-rke]

We successfully switched to postgres v16 on a bare metal setup and also on a docker setup without any issues, so i recommend to do the switch.