| From: | Tod McQuillin <devin(at)spamcop(dot)net> |
|---|---|
| To: | Ian Harding <ianh(at)tpchd(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Differential Backups |
| Date: | 2001-10-30 02:16:05 |
| Message-ID: | 20011030111250.Q81527-100000@glass.pun-pun.prv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Micah Yoder | 2001-10-30 02:22:18 | Re: psql and HTML |
| Previous Message | Alvaro Herrera | 2001-10-30 02:07:24 | Re: Differential Backups |