Script to restore a Heroku postgres database from one Heroku Rails app to another, assuming only one postgres database in the app. I use this to copy production databases onto staging environments.

copy_heroku_db_between_apps.sh

heroku pgbackups:capture --expire -a myapp
heroku pg:reset `heroku config -a myapp-staging | grep -o "\w*POSTGRESQL\w*"` -a myapp-staging
heroku pgbackups:restore `heroku config -a myapp-staging | grep -o "\w*POSTGRESQL\w*"` `heroku pgbackups:url --app myapp` --app myapp-staging
heroku run rake db:migrate -a myapp-staging
heroku restart -a myapp-staging