Ad Widget

Collapse

New server install on Windows w/ compose - missing zabbix user in Postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ayates@signiant.com
    Junior Member
    • Oct 2026
    • 1

    #1

    New server install on Windows w/ compose - missing zabbix user in Postgres


    Windows 11 host PC
    Docker Desktop v 4.96.3

    Following the compose instructions at https://www.zabbix.com/documentation...docker-compose

    C:\Users\ayates\zabbix-docker>docker compose -f ./compose_pgsql.yaml up -d
    WARN[0000] service "zabbix-agent": deploy.mode: deploy.mode is only honored in Swarm mode
    ✔ Image zabbix/zabbix-server-pgsql:alpine-7.4-latest Pulled
    ✔ Image postgres:17-alpine Pulled
    ✔ Image zabbix/zabbix-web-nginx-pgsql:alpine-7.4-latest Pulled
    ✔ Network zabbix-docker_tools_frontend Created
    ✔ Network zabbix-docker_database Created
    ✔ Volume zabbix-docker_snmptraps Created
    ✔ Network zabbix-docker_frontend Created
    ✔ Network zabbix-docker_backend Created
    ✔ Container zabbix-docker-postgres-server-1 Healthy
    - Container zabbix-docker-server-db-init-1 Waiting
    - Container zabbix-docker-zabbix-web-nginx-pgsql-1 Starting
    - Container zabbix-docker-zabbix-server-1 Starting


    From the Postgres container log:

    PostgreSQL Database directory appears to contain a database; Skipping initialization
    2026-10-29 21:05:07.009 UTC [1] LOG: starting PostgreSQL 17.11 on x86_64-pc-linux-musl, compiled by gcc (Alpine 15.2.0) 15.2.0, 64-bit
    2026-10-29 21:05:07.009 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
    2026-10-29 21:05:07.009 UTC [1] LOG: listening on IPv6 address "::", port 5432
    2026-10-29 21:05:07.016 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    2026-10-29 21:05:07.039 UTC [29] LOG: database system was shut down at 2026-10-29 21:02:30 UTC
    2026-10-29 21:05:07.076 UTC [1] LOG: database system is ready to accept connections
    2026-10-29 21:05:11.270 UTC [41] FATAL: role "zabbix" does not exist
    2026-10-29 21:05:11.960 UTC [42] FATAL: password authentication failed for user "zabbix" zz0.4g66ynfn6kizz


    The db-init container sits in a loop trying to connect with Postgres ever 5s, and getting the role does not exist error each time.

    I have checked all the config files and environment variables, and all usernames and passwords look to be 'zabbix'.

    My theory is that Postgres is thinking there is already a database, and thus not running the script to create the zabbix user. But I don't how that could be, as this is fresh everything.

    Any idea would be more than welcome.


    Thanks,

    Allan.
Working...