Hi Frthouse, go look for a tool like barman using the rsync option.
Another tool might be PG backrest.
Just go to PostgreSQL.org, downloads and search the software libraries.
https://www.postgresql.org/download/products/1-administrationdevelopment-tools/
Good luck,
Magnus Rolf
From: Firthouse banu <penguinsfairy@xxxxxxxxx>
Sent: Monday, March 7, 2022 6:53:32 AM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Incremental Postgres database backup
Sent: Monday, March 7, 2022 6:53:32 AM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Incremental Postgres database backup
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 ..
Thanks in advance
Regards
Firthouse
