Postgres authentication failed for dbuser in Immich, but only when deployed via Portainer.

[benou2]

Ask a Question!

Hello,

My Immich is working well with 'docker compose' but not with 'stacks' under portainer.

issue is not my environnement set with password. Tested with : sql -U postgres -h 172.18.0.3

Working well but unsecured with : 'host all all all trust' under 'pg_hba.conf'
error :
Using SSD storage PostgreSQL Database directory appears to contain a database; Skipping initialization 2025-11-16 14:32:57.374 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" 2025-11-16 14:32:57.374 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" 2025-11-16 14:32:57.401 UTC [1] LOG: starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit 2025-11-16 14:32:57.401 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2025-11-16 14:32:57.402 UTC [1] LOG: listening on IPv6 address "::", port 5432 2025-11-16 14:32:57.404 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2025-11-16 14:32:57.407 UTC [32] LOG: database system was shut down at 2025-11-16 14:32:14 UTC 2025-11-16 14:32:57.413 UTC [1] LOG: database system is ready to accept connections 2025-11-16 14:33:01.511 UTC [42] FATAL: password authentication failed for user "postgres" 2025-11-16 14:33:01.511 UTC [42] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" 2025-11-16 14:33:05.828 UTC [57] FATAL: password authentication failed for user "postgres" 2025-11-16 14:33:05.828 UTC [57] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" 2025-11-16 14:33:10.055 UTC [58] FATAL: password authentication failed for user "postgres" 2025-11-16 14:33:10.055 UTC [58] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" 2025-11-16 14:33:14.667 UTC [59] FATAL: password authentication failed for user "postgres" 2025-11-16 14:33:14.667 UTC [59] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" 2025-11-16 14:33:19.407 UTC [61] FATAL: password authentication failed for user "postgres" 2025-11-16 14:33:19.407 UTC [61] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"

conf file without envirennemnent settings :
`services:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
volumes:
- ${UPLOAD_LOCATION}:/data
- /etc/localtime:/etc/localtime:ro
depends_on:
- redis
- database
restart: always
healthcheck:
disable: false
networks:
- frontend
- backend

immich-machine-learning:
container_name: immich_machine_learning
image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
volumes:
- model-cache:/cache
restart: always
healthcheck:
disable: false
networks:
- backend

redis:
container_name: immich_redis
image: docker.io/valkey/valkey:8@sha256:81db6d39e1bba3b3ff32bd3a1b19a6d69690f94a3954ec131277b9a26b95b3aa
healthcheck:
test: redis-cli ping || exit 1
restart: always
networks:
- backend

database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
POSTGRES_INITDB_ARGS: '--data-checksums'
# Uncomment the DB_STORAGE_TYPE: 'HDD' var if your database isn't stored on SSDs
# DB_STORAGE_TYPE: 'HDD'
volumes:
- ${DB_DATA_LOCATION}:/var/lib/postgresql/data
shm_size: 128mb
restart: always
networks:
- backend

volumes:
model-cache:

networks:
frontend:
external: true
backend:
external: true`

Thank you in advance for you time !!!!