Backup & Recovery

# Daily backup script
#!/bin/bash
pg_dump -h postgres -U postgres game | gzip > backup-$(date +%Y%m%d).sql.gz

# Upload to S3
aws s3 cp backup-$(date +%Y%m%d).sql.gz s3://backups/

# Restore from backup
gunzip < backup-20250110.sql.gz | psql -h postgres -U postgres game

# Configure mc client
mc alias set local http://minio:9000 minioadmin minioadmin
mc alias set remote https://backup-minio.com access-key secret-key

# Set up replication
mc replicate add local/packages --remote-bucket remote/packages-backup