[clug] database backups with git
bob at cs.anu.edu.au
Thu Jun 7 19:46:20 MDT 2012
I have been playing with keeping daily text dumps of my database in
git, in lieu of rotating or date-stamping them. I haven't seen many
references on the web about people doing this. Is it a good idea or
For example, daily PostgreSQL database dumps of a mediawiki site over
a 3 month period get up over 500MB, but in git, that is reduced to
around 160MB. Then I can rsync the git repository of the backup file
to another server a bit faster (most of the hashes are the same, only
the new ones get to go over the wire).
Anyone else use a VCS for maintaining snapshots of backup files/logs?
What is the downside?
More information about the linux