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
differentialbackups through the day. I should be able to generate dumps throughout the day, generate a diff from my
baselinedump, and just keep the diff, right? Then to do a restore I would just patch for the point in time I wanted to
restoreto? Seems like it would work, but whether it would save any hard drive space would depend on how much activity
thedatabase saw. Anyone doing this now?
>
>Ian A. Harding
>Programmer/Analyst II
>Tacoma-Pierce County Health Department
>(253) 798-3549
>mailto: ianh@tpchd.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/
