> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
