docker-compose.yml

services:
  postgres:
    # Custom image: postgres:17 plus the pldebugger extension compiled from
    # source (see docker/Dockerfile).
    build:
      context: ./docker
    image: pg-gui-postgres:17
    container_name: pg-gui-test
    environment:
      POSTGRES_USER: pgui
      POSTGRES_PASSWORD: pgui
      POSTGRES_DB: pgui_test
    # pg_stat_statements and plugin_debugger (pldebugger) must be preloaded at
    # server start; the extensions themselves are created in docker/init/.
    command: postgres -c shared_preload_libraries=pg_stat_statements,plugin_debugger
    # 5433 on the host to avoid clashing with the locally running Postgres on 5432
    ports:
      - "5433:5432"
    volumes:
      - ./docker/init:/docker-entrypoint-initdb.d:ro
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U pgui -d pgui_test"]
      interval: 2s
      timeout: 2s
      retries: 15