Would a storage block level incremental like zfs work? On December 19, 2017 11:12:48 AM EST, Rakesh Kumar <rakeshkumar...@mail.com> 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.