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

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(dot)jackson(at)broadcom(dot)com>
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/Compression
>
> Any suggestions would be appreciated.
>
> Craig Jackson
>