Re: Incremental Postgres database backup

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(at)denninger(dot)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(at)denninger(dot)net
> *The Market Ticker*
> *[S/MIME encrypted email preferred]*
>