Re: Incremental Postgres database backup - Mailing list pgsql-admin

From Firthouse banu
Subject Re: Incremental Postgres database backup
Date
Msg-id CAK_Ha4yHX7hQk6X=7qb7sD_PH5+f4O5dH6_qpNVZMfJcLhMayQ@mail.gmail.com
Whole thread Raw
In response to Re: Incremental Postgres database backup  (Karl Denninger <karl@denninger.net>)
List 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 by date:

Previous
From: Ron
Date:
Subject: Re: Incremental Postgres database backup
Next
From: Karl Denninger
Date:
Subject: Re: Incremental Postgres database backup