Heroku new pg:backups data script

data

#!/bin/bash

set -x

set -e

DATABASE='YOUR_DEV_DATABASE'
HEROKU_APP='YOUR_HEROKU_APP'

dropdb ${DATABASE}
createdb ${DATABASE}

if [ -z $BACKUP_ID ]; then
    heroku pg:backups capture DATABASE_URL --app ${HEROKU_APP}
    DUMP_FILE="db/${HEROKU_APP}-latest.dump"
else
    DUMP_FILE="db/${HEROKU_APP}-${BACKUP_ID}.dump"
fi

BACKUP_ID=`heroku pg:backups --app ${HEROKU_APP} | grep -Ehom1 "^b\d{3}"`
BACKUP_URL=`heroku pg:backups public-url --app ${HEROKU_APP}`

if [ ! -f $DUMP_FILE ]; then
    echo $BACKUP_URL
    curl -o $DUMP_FILE $BACKUP_URL
fi
pg_restore --verbose --no-acl --no-owner -d ${DATABASE} $DUMP_FILE