Re: Incremental Postgres database backup

[Karl Denninger <karl@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx
The Market Ticker
[S/MIME encrypted email preferred]

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature