flexible Database Connection in Dockercontainer

I tried on my Ubuntu machine to run the openproject:17.4-slim container with the database URL parameter.

docker run -d --name openproject --restart=unless-stopped
-p 8080:80 --net local
-e DATABASE_URL=postgres://user:pwd@127.0.0.1:5432/openproject
-e OPENPROJECT_HOST__NAME=openproject.lab:8012
-e OPENPROJECT_HTTPS=false
-e OPENPROJECT_DEFAULT__LANGUAGE=en
-e SECRET_KEY_BASE=****
-v /media/share/docker/openproject/assets:/var/openproject/assets
openproject/openproject:17.4-slim

And after checking the logs, I found out that this version requires Postgres 17. Without any more profound investigation, it seems to me not always necessary to force upgrades to the latest available version of the DBMS. If there are some specific PostgreSQL features used, it makes more sense to define a minimal version like Postgres 11. So I mention a configuration switch initialized by default with the really minimal version of Postgres is needed. Especially if an ORM like Hibernate is used, there is huge flexibility. Also, the latest JDBC driver has minimal requirements; they do not always force the latest version. Maybe it could also be an option to include different JDBC drivers in the assets folder.

-e POSTGRES_VERSION = 14, ..., 18

It is really inconvenient for complex productive systems to always force a DBMS upgrade.

[1] https://bucardo.org/postgres_all_versions

The issue names no repository files or tests. Start by tracing the openproject:17.4-slim image configuration and the DATABASE_URL path from the shown Docker command, then determine where the PostgreSQL 17 requirement is imposed. Done means a clearly defined way to use supported PostgreSQL versions without breaking the image or database-driver setup.