example script to upgrade a heroku postgresql database

upgrade_heroku_pg.sh

#!/bin/bash
set -x
set -e

export APP_NAME=staging-webfarmforeman
export NEW_DB_NAME=HEROKU_POSTGRESQL_JADE

heroku addons:add pgbackups --app $APP_NAME
heroku addons:add heroku-postgresql:hobby-basic --app $APP_NAME
heroku pg:wait --app $APP_NAME
heroku maintenance:on --app $APP_NAME
# heroku ps:scale worker=0 --app $APP_NAME
heroku pgbackups:transfer DATABASE_URL ${NEW_DB_NAME}_URL --app $APP_NAME

heroku pg:promote $NEW_DB_NAME
heroku maintenance:on --app $APP_NAME
# heroku ps:scale worker=1 --app $APP_NAME