Manual Db Bkrg Better

rsync -av /var/lib/postgresql/data/ /backup/db_physical_20260414/

| Risk | Description | Mitigation | |------|-------------|-------------| | | Copying files while writes occur → corruption | Use DB-native consistent snapshot (e.g., FLUSH TABLES WITH READ LOCK in MySQL) | | Log drift | WAL/logs missing between base backup and restore point | Manually archive logs continuously, even without automation | | Metadata mismatch | Restoring to different DB version or OS | Document exact version + uname -a in backup manifest | | Human error path | Wrong directory, incomplete copy | Script each manual step, but keep scripts read-only; force manual confirmation | | RTO blowout | Recovery takes 10x expected | Time each step quarterly. Add 200% buffer. | manual db bkrg

"backup_id": "MANUAL-20260414-0845", "dba": "jsmith", "db_type": "PostgreSQL 14.5", "method": "pg_basebackup -Ftar", "consistency": "pg_start_backup()", "checksum_primary": "a3f5c...", "location": "/mnt/tape/001234", "restore_tested": "2026-03-01", "rto_actual_min": 47 but keep scripts read-only

: You manually moved cash to buy stocks, bonds, or ETFs. "db_type": "PostgreSQL 14.5"