| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Patrick Macdonald <patrickm(at)redhat(dot)com> |
| Cc: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Incremental backup |
| Date: | 2003-02-13 22:56:46 |
| Message-ID: | 200302132256.h1DMukQ26358@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-02-13 22:58:18 | Re: [HACKERS] Changing the default configuration |
| Previous Message | Bruce Momjian | 2003-02-13 22:55:16 | Re: location of the configuration files |