| From: | "Timothy H(dot) Keitt" <tklistaddr(at)keittlab(dot)bio(dot)sunysb(dot)edu> |
|---|---|
| To: | |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Differential Backups |
| Date: | 2001-10-29 23:44:53 |
| Message-ID: | 3BDDE9F5.9070904@keittlab.bio.sunysb.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tried it. GNU diff chokes on very large files. It would be so nice if
incremental dumps were native to pgsql.
Tim
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? 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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Stony Brook, New York 11794 USA
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2001-10-30 01:01:39 | Re: UNICODE |
| Previous Message | Doug McNaught | 2001-10-29 23:42:24 | Re: Differential Backups |