Commit bc638502

mo k <mo@mokhan.ca>
2012-06-20 03:41:05
trying to backup db and copy via scp.
master
1 parent 6245c4c
Changed files (1)
capfile
capfile
@@ -20,7 +20,9 @@ task :update_bundler do
 end
 
 task :backup_db do
-  run "pg_dump -U postgress cakeside_production -f #{filename}"
+  filename= "#{Time.now.strftime('%Y-%m-%d')}.sql"
+  run "pg_dump cakeside_production > ~/db/backups/#{filename}"
+  download("~/db/backups/#{filename}", "db/backups/", :via => :scp, :recursive => true)
 end
 
 task :restore_db do