Automatically capture, download and import a postgres DB from Heroku. You can supply an argument to the script to specify the app to use like this: `heroku_db_import.sh -amyapp` It reads the username and database name from config/database.yml

heroku_db_import.sh

heroku pgbackups:capture $1 --expire
if [ "$?" == 0 ]
  then
  rake db:drop db:create
  curl -o heroku_db_backup.dump `heroku pgbackups:url $1`
  pg_restore --verbose --clean --no-acl --no-owner -h localhost `ruby -e "require 'yaml';db = YAML::load(File.read 'config/database.yml')['development']; puts ' -U ' + (db['username'] || 'postgres') + ' -d ' + db['database']"` heroku_db_backup.dump
  rm heroku_db_backup.dump
fi