Add a db::backup recipe to handle database backups

[chef.git] / cookbooks / db / templates / default / backup-db.erb

diff --git a/cookbooks/db/templates/default/backup-db.erb b/cookbooks/db/templates/default/backup-db.erb
new file mode 100644 (file)
index 0000000..3ad1020
--- /dev/null
+++ b/cookbooks/db/templates/default/backup-db.erb
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+# DO NOT EDIT - This file is being maintained by Chef
+
+D=`date +%Y-%m-%d`
+F=/tmp/osm-${D}.dmp
+
+pg_dump --user=backup --format=custom --file=$F openstreetmap
+
+rsync $F backup.openstreetmap.org::backup
+
+rm -f $F