Patrick Macdonald wrote:
> > But why would someone want incremental backups compared to PITR? The
> > backup would be mixture of INSERTS, UPDATES, and DELETES, right? Seems
> > pretty weird. :-)
>
> Yeah, it's a different method of producing a similar outcome. However, many
> companies do not want to be concerned with the management (and space)
> of archived logs. Incremental backup allows them the option of performing
> a full backup and then only backing up the modifications on a regular basis.
> When it's time to restore, they'll restore the full backup and then the
> proper sequence of incremental backups.
Wow, I never even thought that was possible. Do other db's support that
feature?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073