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