Re: Incremental backup - Mailing list pgsql-hackers

From Patrick Macdonald
Subject Re: Incremental backup
Date
Msg-id 3E4C372D.B3E90C89@redhat.com
Whole thread Raw
In response to Re: Incremental backup  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Incremental backup
List 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


pgsql-hackers by date:

Previous
From: "Shahbaz Chaudhary"
Date:
Subject: Re: java access to the backend (non jdbc)?
Next
From: Adam Haberlach
Date:
Subject: Re: location of the configuration files