Runbook: DB Backup & Restore

PostgreSQL (DO Managed)

Backup

# pg_dump přes DO Managed DB connection string
pg_dump "$DATABASE_URL" > /root/backups/pg_$(date +%Y%m%d_%H%M%S).sql

Restore

psql "$DATABASE_URL" < /root/backups/pg_<timestamp>.sql

Automatický backup

TODO: Nastavit cron pro denní backup.

Ověření integrity

# Zkontrolovat velikost dumpu (nesmí být prázdný)
ls -la /root/backups/pg_*.sql

# Test restore na staging
psql "$STAGING_DATABASE_URL" < /root/backups/pg_<timestamp>.sql