Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud - Mailing list pgsql-performance

From Nikolay Samokhvalov
Subject Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud
Date
Msg-id CANNMO+KpEnqESihiJ+Ja+4=Q2hJvFs+mW9sCMk3BbFM8_UXnDg@mail.gmail.com
Whole thread Raw
In response to Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud  (Craig Jackson <craig.jackson@broadcom.com>)
List pgsql-performance
Tree view
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@broadcom.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

pgsql-performance by date:

Previous
From: Craig Jackson
Date:
Subject: Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud
Next
From: Michael Lewis
Date:
Subject: Re: autovacuum locking question