Fix for Postgres Authentication Errors When Deploying Dify with Docker on Windows 11

[stud2008]

If you encounter these Postgres database errors when deploying Dify using Docker on Windows 11:

FATAL:  password authentication failed for user "postgres"
DETAIL:  Role "postgres" does not exist.

or

FATAL:  password authentication failed for user "postgres"
DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"

Don't panic – this is likely related to the file permissions mounting mechanism in Windows 11 + Docker Desktop + WSL2. Hardcoding credentials bypasses an underlying issue.

Solution: Modify credentials in docker/docker-compose.yaml to use hardcoded values:

db:
    image: postgres:15-alpine
    restart: always
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: difyai123456  # Hardcoded password
      POSTGRES_DB: dify
      PGDATA: ${PGDATA:-/var/lib/postgresql/data/pgdata}

Hope this helps!

[madlogos]

It doesn't work for me (docker on Win10).