pgbackups

Jump to bottom Edit New page

mattharley edited this page Sep 23, 2014 · 1 revision

PGBackups for Heroku

export PRODUCTION_APP=hpflsk3
export TEST_APP=hpflsk3-test
export TEST_APP_DATABASE_NAME=`heroku pg --app=$TEST_APP | grep === | awk '{print $2}'`

heroku pgbackups:capture --app=$PRODUCTION_APP

export PRODUCTION_DATABASE_URL=`heroku pgbackups:url --app=$PRODUCTION_APP`
heroku pgbackups:restore $TEST_APP_DATABASE_NAME --app=$TEST_APP --confirm $TEST_APP $PRODUCTION_DATABASE_URL