Commit 8720b16b

mo khan <mo@mokhan.ca>
2013-06-05 05:09:43
clean up pg_dump command with help from heroku docs
master
1 parent 84f7dcb
Changed files (1)
capfile
capfile
@@ -16,7 +16,9 @@ end
 
 task :backup_db do
   filename = "#{deploy_env}-#{Time.now.strftime('%Y-%m-%d')}.sql"
-  run "pg_dump --clean cakeside_production > ~/db/backups/#{filename}"
+  #run "pg_dump --clean cakeside_production > ~/db/backups/#{filename}"
+  run "PGPASSWORD=password pg_dump -Fc --no-acl --no-owner -h localhost -U cakeside cakeside_production > ~/db/backups/#{filename}"
+  #PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dump
   download("db/backups/#{filename}", "db/backups/", :via => :scp, :recursive => true)
 end