Re: Differential Backups - Mailing list pgsql-general

From Tod McQuillin
Subject Re: Differential Backups
Date
Msg-id 20011030111250.Q81527-100000@glass.pun-pun.prv
Whole thread Raw
In response to Differential Backups  ("Ian Harding" <ianh@tpchd.org>)
List pgsql-general
On Mon, 29 Oct 2001, Ian Harding wrote:

> I have been thinking about backups.  I currently do one a day.
> However, I thought it might be nice to get differential backups
> through the day.  I should be able to generate dumps throughout the
> day, generate a diff from my baseline dump, and just keep the diff,
> right?  Then to do a restore I would just patch for the point in time
> I wanted to restore to?

This is exactly what rcs (http://www.cs.purdue.edu/homes/trinkle/RCS/) and
cvs (http://www.cvshome.org/) do.

If you check each new pgdump into an rcs file, rcs saves only the diffs
from the prior revision.

I'm not sure if this would meet your needs or not, but it's worth a look.
--
Tod McQuillin



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Differential Backups
Next
From: Paul Tomblin
Date:
Subject: Re: Differential Backups