Hi all, I'm trying to get my docker compose to run properly but have been facing the following error...
a

arnmishra

about 2 years ago
Hi all, I'm trying to get my docker compose to run properly but have been facing the following error. Not sure why it can't detect the correct password/database:
2023-03-14 09:52:34 2023-03-14 16:52:34.972 UTC [129] FATAL:  role "doss-username" does not exist
2023-03-14 09:52:39 2023-03-14 16:52:39.086 UTC [131] FATAL:  password authentication failed for user "doss-username"
2023-03-14 09:52:39 2023-03-14 16:52:39.086 UTC [131] DETAIL:  Role "doss-username" does not exist.
2023-03-14 09:52:39     Connection matched pg_hba.conf line 99: "host all all all md5"
with the following docker compose:
version: '3.8'
services:
  # Database for developers running app locally
  doss-postgres-local:
    platform: linux/amd64
    container_name: doss-postgres-local
    image: postgis/postgis:12-3.3
    environment:
      POSTGRES_USER: doss-username
      POSTGRES_PASSWORD: doss-password
      POSTGRES_DB: doss-localdb
      PGDATA: /var/lib/postgresql/data
    ports:
      - 5432:5432
    networks:
      - app_network
    volumes:
      - doss-localdb:/var/lib/postgresql/data
    restart: unless-stopped
    healthcheck:
      test: ['CMD', 'pg_isready', '-U', 'doss-username']
      interval: 5s
      timeout: 5s
      retries: 5
    cap_add:
      - NET_ADMIN

  supertokens:
    image: registry.supertokens.io/supertokens/supertokens-postgresql:4.4
    depends_on:
      doss-postgres-local:
        condition: service_healthy
    ports:
      - 3567:3567
    environment:
      POSTGRESQL_CONNECTION_URI: 'postgresql://doss-username:doss-password@doss-postgres-local:5432/doss-localdb'
    networks:
      - app_network
    restart: unless-stopped
    healthcheck:
      test: >
        bash -c 'exec 3<>/dev/tcp/127.0.0.1/3567 && echo -e "GET /hello HTTP/1.1\r\nhost: 127.0.0.1:3567\r\nConnection: close\r\n\r\n" >&3 && cat <&3 | grep "Hello"'
      interval: 10s
      timeout: 5s
      retries: 5