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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])