hard20 pts · first answer countsbackup-recoveryhigh-availability
Restore takes longer than the RTO
Your only backup of a 3 TB database is a nightly pg_dump. A restore drill takes 19 hours, mostly building indexes, but the RTO is 2 hours. What is the best change?
Discussion 0
Join free to post in the discussion.
Related questions
- Full vs incremental backupDatabase Administrator
- Logical vs physical backupDatabase Administrator
- Proving backups workDatabase Administrator
- RPO and RTODatabase Administrator
- What PITR needsDatabase Administrator
- Risk of asynchronous replicationDatabase Administrator
- Is pg_dump consistent?Database Administrator
- Restoring a Percona XtraBackupDatabase Administrator