heroku and postgres script to restore from the latest backup

pg_hrefresh.sh

#!/bin/sh

DIR="$(basename $(PWD))"
DIR="${DIR/-/_}"
if [ "$1" == "execute" ]
  then
    if [ ! -f 'dump.db' ]
      then
        echo "downloading backup"
        curl `heroku pgbackups:url` > dump.db
    fi
    pg_restore --verbose --clean --no-acl --no-owner -d $DIR dump.db
    echo "restore complete. Run rake tasks to update any necessary db changes"
  else
    echo "add execute to run"
fi