Hi,
We are in the process of migrating an oracle database to postgres in Google Cloud and are investigating backup/recovery tools. The database is size is > 20TB. We have an SLA that requires us to be able to complete a full restore of the database within 24 hours. We have been testing pgbackreset, barman, and GCP snapshots but wanted to see if there are any other recommendations we should consider.
Desirable features
- Parallel backup/recovery
- Incremental backups
- Incremental backups
- Backup directly to a GCP bucket
- Deduplication/Compression
Any suggestions would be appreciated.
Craig Jackson