Consider WAL-G. It works well with GCS nowadays. We have a good fresh experience of using it on GCP, for multi-TB databases.
BTW, what is your opinion on using GCE snapshots in this context? You mention that you've consider them. Thoughts?
Thanks,
Nik
On Thu, Dec 5, 2019 at 09:48 Craig Jackson <craig.jackson@xxxxxxxxxxxx> wrote:
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/CompressionAny suggestions would be appreciated.Craig Jackson
