On December 19, 2017 11:12:48 AM EST, Rakesh Kumar <rakeshkumar464@xxxxxxxx> wrote:
There are multiple solutions to doing incremental backups with
PostgreSQL, so I'm not sure why you're saying that they don't exist,
because that's really not accurate.
PG's incremental backup is essentially WAL logs applied to a point in time. I am talking about true incremental backup where the db backs up only the changed blocks after the last full backup. In a DW system where most of the time it is append only, it makes a huge difference in backup time.
I believe there is one tool which looks at mtime/atime of each of the data file and takes the decision to back it up or lot. Not sure how robust it is.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
