Backup & Restore

docker compose exec postgres pg_dump -U verilock verilock > backup-$(date +%Y%m%d-%H%M%S).sql

docker compose exec postgres pg_dump -U verilock verilock | gzip > backup-$(date +%Y%m%d).sql.gz

crontab -e

0 2 * * * cd /path/to/verilock && docker compose exec -T postgres pg_dump -U verilock verilock | gzip > /backups/verilock-$(date +\%Y\%m\%d).sql.gz

# Install mc (MinIO client) on host
docker compose exec minio mc mirror local/verilock-documents /tmp/backup-documents

# Copy from container
docker compose cp minio:/tmp/backup-documents ./backup-documents

docker compose exec minio mc alias set aws https://s3.amazonaws.com YOUR_KEY YOUR_SECRET
docker compose exec minio mc mirror local/verilock-documents aws/your-backup-bucket/verilock/

# Stop the app (prevent writes during restore)
docker compose stop app

# Restore
cat backup-20260317.sql | docker compose exec -T postgres psql -U verilock -d verilock

# Or from gzip
gunzip -c backup-20260317.sql.gz | docker compose exec -T postgres psql -U verilock -d verilock

# Restart
docker compose start app

docker compose cp ./backup-documents minio:/data/verilock-documents
docker compose restart minio