docker-compose.postgres.yml

# PostgreSQL override for Skymmich
#
# Layer this on top of the base compose file to use PostgreSQL instead of SQLite:
#   docker compose -f docker-compose.yml -f docker-compose.postgres.yml up -d
#   docker compose -f docker-compose.prod.yml -f docker-compose.postgres.yml up -d
#
# Requires POSTGRES_PASSWORD set in .env or environment:
#   echo "POSTGRES_PASSWORD=your_secure_password" > .env

services:
  skymmich:
    environment:
      - DATABASE_URL=postgresql://skymmich:${POSTGRES_PASSWORD}@skymmich-db:5432/skymmich
    depends_on:
      skymmich-db:
        condition: service_healthy
    networks:
      - skymmich-network

  skymmich-db:
    image: postgres:15-alpine
    container_name: skymmich-db
    restart: unless-stopped
    environment:
      - POSTGRES_DB=skymmich
      - POSTGRES_USER=skymmich
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRES_INITDB_ARGS=--encoding=UTF-8 --lc-collate=C --lc-ctype=C
    volumes:
      - skymmich-database:/var/lib/postgresql/data
    networks:
      - skymmich-network
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U skymmich -d skymmich"]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s
    # Don't expose PostgreSQL port externally for security

networks:
  skymmich-network:
    driver: bridge

volumes:
  skymmich-database:
    driver: local