Pull down a database from Heroku. Assumes Rails db names.

dbsync.sh

#!/bin/bash

APPNAME="$1"
REMOTE="$2"

if [[ "$3" != "" ]]; then
    ENVIRONMENT="$3"
else
    ENVIRONMENT="development"
fi
DATABASE=$APPNAME
DATABASE+="_"
DATABASE+=$ENVIRONMENT

echo "App: $APPNAME"
echo "Remote: $REMOTE"
echo "Rails Env: $ENVIRONMENT"
echo "Database: $DATABASE"

function run_restore {
        `pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d "$DATABASE" latest.dump`
}

`heroku pg:backups:capture --remote $REMOTE`
`heroku pg:backups:download --remote $REMOTE`
run_restore
`rm latest.dump`