compose.dev.yml

services:
  postgres:
    image: postgres
    restart: always
    volumes:
      - ./data:/var/lib/postgresql/data
    env_file:
      - path: .env
        required: true
    ports:
      - "5432:5432"
  postgres_backup:
    # Build locally for development
    build:
      context: .
      dockerfile: Dockerfile
    depends_on:
      - postgres
    volumes:
      - ./backups:/backups
      - /etc/localtime:/etc/localtime:ro
    environment:
      - POSTGRES_HOST=postgres
      - BACKUP_INTERVAL=86400  # 24 hours
      - RETENTION_DAYS=7       # Keep local backups for 7 days
      - S3_RETENTION_DAYS=30   # Keep S3 backups for 30 days (optional)
      # S3 configuration (set these in .env file)
      # - S3_BUCKET=your-backup-bucket
      # - S3_PREFIX=db-backups
      # AWS credentials should be set in .env file:
      # - AWS_ACCESS_KEY_ID=your-access-key
      # - AWS_SECRET_ACCESS_KEY=your-secret-key
      # - AWS_DEFAULT_REGION=us-east-1
    env_file:
      - path: .env
        required: true