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

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: Postgres backup tool recommendations for multi-terabyte databasein Google Cloud
Дата
Msg-id CANNMO+KpEnqESihiJ+Ja+4=Q2hJvFs+mW9sCMk3BbFM8_UXnDg@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres backup tool recommendations for multi-terabyte database inGoogle Cloud  (Craig Jackson <craig.jackson@broadcom.com>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

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