postgres large database backup

Поиск
Список
Период
Сортировка
Hi, 

I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way.

The scheduled backup will be used for PITR purposes.

So please let me know how I should do it in a quicker backup for my 10TB database ? Is there any tool to take backups and subsequently incremental backups in a faster way and restore it for PITR in a faster way when required.

What should be the exact approach for scheduling such backups so that it can be restored in a faster way ?



Regards.

В списке pgsql-general по дате отправления:

Предыдущее
От: Amitabh Kant
Дата:
Сообщение: Re: Finding free time period on non-continous tstzrange field values
Следующее
От: Вадим Самохин
Дата:
Сообщение: Re: postgresql 13.1: precision of spatial operations