| From: | "Ian Harding" <ianh(at)tpchd(dot)org> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Differential Backups |
| Date: | 2001-10-29 20:22:44 |
| Message-ID: | sbdd4a24.090@mail.tpchd.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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? Seems like it would work, but whether it would save any hard drive space would depend on how much activity the database saw. Anyone doing this now?
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh(at)tpchd(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-29 20:54:15 | Re: Select limit... erm so.. |
| Previous Message | Mihai Gheorghiu | 2001-10-29 19:54:53 | Table restructuring with referential integrity |