docker-compose.yml

version: '3.8'

services:
  pgproxy:
    build: .
    ports:
      - "8080:8080"
    environment:
      # PGProxy Server Configuration
      PGPROXYSECRET: "your-super-secret-key-change-this"
      PGPROXYADDRESS: "0.0.0.0"
      PGPROXYPORT: "8080"
      PGPROXYHEALTHCHECK: "/health"
      
      # Connection Pool Configuration
      PGPOOLMINSIZE: "2"
      PGPOOLMAXSIZE: "20"
      PGPOOLIDLECONN: "10"
      PGPOOLACQUIRETIMEOUT: "30"
      PGPOOLBORROWTIMEOUT: "120"
      PGPOOLRETRYINTERVAL: "5"
      
      # PostgreSQL Connection Configuration
      PGHOST: "postgres"
      PGPORT: "5432"
      PGDATABASE: "postgres"
      PGUSER: "postgres"
      PGPASSWORD: "postgres"
    depends_on:
      - postgres
    restart: unless-stopped
    networks:
      - pgproxy-network

  # Optional: Include a PostgreSQL instance for testing
  postgres:
    image: postgres:15-alpine
    environment:
      POSTGRES_DB: postgres
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
    ports:
      - "5432:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data
    restart: unless-stopped
    networks:
      - pgproxy-network

volumes:
  postgres_data:

networks:
  pgproxy-network:
    driver: bridge