Change the SQL Lite Database to the Remote PostgreSQL Database via SSL

[sharbich]

Hello,
i want my Nginx proxy manager to store its configuration on a remote PostgreSQL database. I've set up my Nginx as follows using a Docker Compose file:
` file:

nginx_new
container_name: nginx_new
image: 'jc21/nginx-proxy-manager:latest'
restart: unless-stopped
ports:
  # These ports are in format <host-port>:<container-port>
  - '80:80' # Public HTTP Port
  - '443:443' # Public HTTPS Port
  - '81:81' # Admin Web Port
  # Add any other Stream port you want to expose
  # - '21:21' # FTP
environment:
  # Postgres parameters:
  DB_POSTGRES_HOST: '192.168.20.60'
  DB_POSTGRES_PORT: '5432'
  DB_POSTGRES_USER: 'npmdbuser'
  DB_POSTGRES_PASSWORD: '#########'
  DB_POSTGRES_NAME: 'npmdb'
  # Uncomment this if IPv6 is not enabled on your host
  # DISABLE_IPV6: 'true'
  # Import SSL SETTINGS
  DB_POSTGRES_SSL: 'true'
  DB_POSTGRES_SSL_REJECT_UNAUTHORIZED: "false"
volumes:
  - /etc/timezone:/etc/timezone:ro
  - /etc/localtime:/etc/localtime:ro
  - /var/lib/docker/volumes/nginx_data/_data:/data
  - ./letsencrypt:/etc/letsencrypt`

After the build, I get the following error message:
[3/28/2026] [8:56:10 PM] [Global ] › ✖ error Startup Error: no pg_hba.conf entry for host "192.168.20.70", user "npmdbuser", database "npmdb", no encryption error: no pg_hba.conf entry for host "192.168.20.70", user "npmdbuser", database "npmdb", no encryption

If I connect to the database using psql, access works without any problems:
[root@docker-06ff80aa58fb:/app]# psql "host=192.168.20.60 port=5432 dbname=npmdb user=npmdbuser sslmode=require" Password for user npmdbuser: psql (15.16 (Debian 15.16-0+deb12u1), server 16.13 (Ubuntu 16.13-0ubuntu0.24.04.1)) WARNING: psql major version 15, server major version 16. Some psql features might not work. SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off) Type "help" for help. npmdb=> \q

Connection Info:
npmdb=> SELECT ssl, client_addr FROM pg_stat_ssl JOIN pg_stat_activity USING (pid); ssl | client_addr -----+--------------- t | 192.168.20.70 (1 row)

What's the problem with the Docker Compose file?

Can you help me?

Regards, Stefan Harbich