Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud

Поиск
Список
Период
Сортировка
От Craig Jackson
Тема Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud
Дата
Msg-id CA+R1LV5T_upTpOSfwUYFpgBmhDfBj8cRv=yi0CQ2Ygf7nZ3yNA@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Mike Schanne
Дата:
Сообщение: autovacuum locking question
Следующее
От: Craig James
Дата:
Сообщение: Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud