Re: Incremental Postgres database backup

Поиск
Список
Период
Сортировка
От Firthouse banu
Тема Re: Incremental Postgres database backup
Дата
Msg-id CAK_Ha4yHX7hQk6X=7qb7sD_PH5+f4O5dH6_qpNVZMfJcLhMayQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Incremental Postgres database backup  (Karl Denninger <karl@denninger.net>)
Список pgsql-admin
Thanks for your responses Ron, Karl and Magnus Rolf. I will explore on PgBackRest…. 

Thanks 
Firthouse

On Mon, 7 Mar 2022 at 8:01 PM, Karl Denninger <karl@denninger.net> wrote:
On 3/7/2022 09:03, Ron wrote:
On 3/6/22 23:53, Firthouse banu wrote:
Hello Team,

Needed an expert advice.
Can you guys suggest me to a open source tool which can be used to take incremental backup of individual Postgres databases…

We have very large databases whose sizes are again TBs when we do pg_dump or pg_dump all its taking days to complete backups ..

We use PgBackRest, and are very pleased with it.

Ditto here.  It works very well and has the advantage of being able to produce an immediately-startable copy of the master.

One caution; you have to pay attention when doing upgrades, even of minor versions.

The other obvious option is online replication.


--
Karl Denninger
karl@denninger.net
The Market Ticker
[S/MIME encrypted email preferred]

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Incremental Postgres database backup
Следующее
От: Karl Denninger
Дата:
Сообщение: Re: Incremental Postgres database backup