> 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

Reply via email to