docker-compose.yml

# Local development database only. Deployed environments use managed PostgreSQL
# (see docs/adr/002-postgresql-and-hosting.md). Port 5433 on the host to avoid
# colliding with a PostgreSQL already installed locally.
services:
  postgres:
    # Pinned exactly. A floating tag means the day a new major is published, the
    # container restarts against a data directory the new server refuses to open.
    image: postgres:17-alpine
    container_name: ocean-command-db
    restart: unless-stopped
    environment:
      POSTGRES_USER: ocean
      POSTGRES_PASSWORD: ocean_dev_only
      POSTGRES_DB: ocean_command
    ports:
      - '5433:5432'
    volumes:
      - postgres-data:/var/lib/postgresql/data
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U ocean -d ocean_command']
      interval: 5s
      timeout: 5s
      retries: 10

volumes:
  postgres-data: