How do we go about adding PostgreSQL

[Toylerrr]

I tried adding the QGIS_SERVER_LANDING_PAGE_PROJECTS_PG_CONNECTIONS var but it wouldn't connect to my server

[reyemb]

Stuck on that problem as well, did you find a solution?

[Toylerrr]

No I moved on to Lizmap stack instead

[reyemb]

Thank you for replying.

In the meantime I have found a solution by using service files.

Using the same service file in qgis-desktop and qgis-server fixed the problem for me.

my docker-compose.yml looks like:

services:
qgis-server:
image: camptocamp/qgis-server
ports:
- "8380:80"
volumes:
- ./qgis:/etc/qgisserver
- ./pg_service.conf:/etc/postgresql/pg_service.conf
environment:
- PGSERVICEFILE=/etc/postgresql/pg_service.conf
- QGIS_SERVER_LOG_LEVEL=DEBUG

Maybe this helps other people who are stumpling here as well.