Re: Are file system level differential/incremental backups possible?

> If you drop or truncate a table between the full and the incremental backup, will that file be "resurrected"?
>
> Such resurrected files will not disturb PostgreSQL, but if you keep them around, you might end up with a lot of dead files if you have to restore a couple of times.

That makes sense, thank you. At one point, I was doing delta copies
of the database: full one night, then only new/changed files the
following nights -- I am pretty sure that didn't work and thought it
was because the destination had extra files that pg had removed on the
primary. I now use a robocopy /mir which removes files on the
destination that aren't on the primary. This seems to work fine --
but it made me think that PostreSQL doesn't work with the former
process.