docker-compose.yml

services:
  postgres:
    image: postgres:16
    ports:
      # Default to 5433 so host PostgreSQL can own 5432 (see DB_PORT in config/test.exs).
      - "${THREADLINE_DB_PORT:-5433}:5432"
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: threadline_test
      # Lets PgBouncer reach Postgres on the Docker network without SCRAM friction in dev/CI.
      POSTGRES_HOST_AUTH_METHOD: trust
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres -d threadline_test"]
      interval: 5s
      timeout: 5s
      retries: 10

  pgbouncer:
    image: edoburu/pgbouncer:latest
    depends_on:
      postgres:
        condition: service_healthy
    environment:
      DATABASE_URL: postgres://postgres:postgres@postgres:5432/threadline_test
      AUTH_TYPE: scram-sha-256
      POOL_MODE: transaction
      MAX_CLIENT_CONN: 200
      DEFAULT_POOL_SIZE: 5
    ports:
      - "${THREADLINE_PGBOUNCER_PORT:-6432}:5432"