> 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
wherethe db backs up only the changed blocks after the last full backup. In a DW system where most of the time it is
appendonly, 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.