Re: Incremental backup

Patrick Macdonald <patrickm@redhat.com>

From: Patrick Macdonald <patrickm@redhat.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Martin Marques <martin@bugs.unl.edu.ar>, pgsql-hackers@postgresql.org
Date: 2003-02-14T00:24:13Z
Lists: pgsql-hackers
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