Bash script to pull Heroku DB to local environment - note that this creates a manual backup via heroku pgbackups:capture

gistfile1.sh

#!/bin/bash

# call command with bash pull_production_to_local

function LastBackupName () {
  heroku pgbackups --app APPNAME | tail -n 1 | cut -d " " -f 1
}

heroku pgbackups:capture --expire --app APPNAME
new_backup=$(LastBackupName)
curl $(heroku pgbackups:url $new_backup --app APPNAME) -k > db/temporary_backup.dump
dropdb development -h localhost
createdb development -h localhost
pg_restore --verbose --clean --no-acl --no-owner -h localhost -d development db/temporary_backup.dump
rm -f db/temporary_backup.dump