Merge pull request #18 from madebyuppercut/moHEADmaster

Add tasks to backup remote databases and restore them locally.

1 files changed, 11 insertions, 0 deletions

diff --git a/config/recipes/postgresql.rb b/config/recipes/postgresql.rb
index 63fa23b..8788c4b 100644
--- a/config/recipes/postgresql.rb
+++ b/config/recipes/postgresql.rb
@@ -32,4 +32,15 @@ namespace :postgresql do
     run "ln -nfs #{shared_path}/config/database.yml #{release_path}/config/database.yml"
   end
   after "deploy:finalize_update", "postgresql:symlink"
+
+  desc "Backup the database and copy it locally"
+  task :backup, roles: :db, only: {primary: true} do
+    filename = "#{rails_env}-#{Time.now.strftime('%Y-%m-%d-%H-%M')}.dump"
+    backup_path = "#{shared_path}/backups"
+    run "mkdir -p #{shared_path}/backups"
+
+    run "PGPASSWORD='#{postgresql_password}' pg_dump -Fc --no-acl --no-owner -h #{postgresql_host} -U #{postgresql_user} #{postgresql_database} > #{backup_path}/#{filename}"
+    download("#{backup_path}/#{filename}", "tmp/#{filename}", :via => :scp)
+    run_locally "cd tmp; rm database.dump; ln -s #{filename} database.dump"
+  end
 end