Postgres Pro
Downloads
Home   >   mailing lists

Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud - Mailing list pgsql-performance

From Craig Jackson
Subject Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud
Date
Msg-id CA+R1LV5T_upTpOSfwUYFpgBmhDfBj8cRv=yi0CQ2Ygf7nZ3yNA@mail.gmail.com
Whole thread Raw
Responses Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud  (Craig James <cjames@emolecules.com>)
Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
List pgsql-performance
Tree view
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: Mike Schanne
Date:
Subject: autovacuum locking question
Next
From: Craig James
Date:
Subject: Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud