Re: Incremental Postgres database backup

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]/