docker-compose.yml

services:
  postgres:
    # pgvector/pgvector image ships pgvector + pg_trgm pre-installed,
    # matching production (Render Postgres 18 + pgvector 0.8.1).
    image: pgvector/pgvector:pg18
    container_name: code-intel-digest-postgres
    environment:
      POSTGRES_USER: code_intel_user
      POSTGRES_PASSWORD: local_dev_password
      POSTGRES_DB: code_intel
    command: postgres -c log_statement=all -c log_destination=stderr
    ports:
      - "5433:5432"  # Use 5433 to avoid conflict with system PostgreSQL
    volumes:
      # pg18+ expects the parent dir so it can manage version-specific
      # subdirectories (for pg_upgrade compatibility).
      - postgres_data:/var/lib/postgresql
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U code_intel_user"]
      interval: 5s
      timeout: 5s
      retries: 5

volumes:
  postgres_data: