Replace local database with latest heroku dump

replace_with_local_databse

#!/bin/bash
# from app $1 to local database $2
#
# Place this in your /usr/local/bin folder and add execution privelages
# Example usage:
#   replace_with_production_db my_app_name my_app_database_dev

echo “Downloading database from $1...”
curl -o latest_db.dump `heroku pg:backups public-url --app $1`
echo “Dropping database $2...”
dropdb $2
echo “Creating new database - $2...”
createdb $2 -O `whoami`
echo “Restoring database form $1 to $2...”
pg_restore --verbose --clean --no-acl --no-owner -U `whoami` -d $2 latest_db.dump
rm latest_db.dump