Transfert Heroku production db to local dev db

get_production_db.sh

#!/bin/bash

# Get to the Rails app's root directory
cd `dirname $0`/..

APP_DIRECTORY=`pwd`
APP_NAME=`basename $APP_DIRECTORY`

# How-to:
# http://www.ryandaigle.com/a/pgtransfer-is-the-new-taps

if heroku plugins | grep -q "heroku-pg-transfer"
then
  echo "Heroku PG transfer plugin already installed."
else
  echo "Installing Heroku PG transfer plugin."
  heroku plugins:install https://github.com/ddollar/heroku-pg-transfer
fi

# Transfert remote production database to local development database
heroku pg:transfer --to "postgres://localhost/${APP_NAME}_development" --confirm "$APP_NAME"

# App's link to postgres is corrupteda after database has been re-created
# Restart it via pow's / passenger's shortcut
touch tmp/restart.txt