stable/16: Wrong pgsql version in docker-compose.yml

[Kurapikov]

It should be 16 rather than 13.

BR.

[davemc50]

This is still an issue, and a trivial fix, how come such a straightforward issue sits open for six months?

[Tofandel]

It should even be 17

[nWacky]

For existing installations, Postgres data needs to be migrated before the version can be changed from 13 to 16. https://www.openproject.org/docs/installation-and-operations/misc/migration-to-postgresql17/

Probably that's why the Postgres version in docker compose is old.

It would be nice to have a recent recommended Postgres version in docker compose by the default, though

[area51tazz]

Can we just change it to 17 for new installations? Other than the migration commands, I can't remember anything special about updating the docker compose file before pulling it.

[Tofandel]

You can with a docker-compose.override.yml file, if you already migrated your data to postgres 17 or for a new installation

services:
  db:
    image: postgres:17
    environment:
      POSTGRES_USER: openproject
  # If you don't need the nginx reverse proxy
  proxy:
    profiles:
      - donotstart

This file is gitignored, so it will survive a git pull. This is the proper way to make customisations to the docker compose file