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