Postgres backup tool recommendations for multi-terabyte database in Google Cloud

Craig Jackson <[email protected]> Thu, 5 Dec 2019 10:47:46 -0700

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CA+R1LV5T_upTpOSfwUYFpgBmhDfBj8cRv=yi0CQ2Ygf7nZ3yNA@mail.gmail.com>

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
- Backup directly to a GCP bucket
- Deduplication/Compression

Any suggestions would be appreciated.

Craig Jackson