Bruce Momjian wrote: > > Patrick Macdonald wrote: > > > 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?
I know Oracle and DB2 have incremental backup in their arsenal (and iirc, SQL Server has something called "differential backup"). Whatever the name, it's a win at the enterprise level. Cheers, Patrick ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster