services:
  postgres:
    image: postgres:16-alpine
    container_name: vsr-postgres
    restart: unless-stopped
    environment:
      POSTGRES_DB: ${POSTGRES_DB:-vsr_dev}
      POSTGRES_USER: ${POSTGRES_USER:-vsr_app}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-vsr_dev_password}
    ports:
      - "5432:5432"
    volumes:
      - vsr_pg_data:/var/lib/postgresql/data
      - ../infra/sql:/docker-entrypoint-initdb.d:ro
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER:-vsr_app} -d ${POSTGRES_DB:-vsr_dev}"]
      interval: 5s
      timeout: 5s
      retries: 10

volumes:
  vsr_pg_data:
    driver: local