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.