Horton

Re: Incremental backup

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Patrick Macdonald <patrickm@redhat.com>
Cc: Martin Marques <martin@bugs.unl.edu.ar>, pgsql-hackers@postgresql.org
Date: 2003-02-13T22:56:46Z
Lists: pgsql-hackers 
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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073