Skip to content

Instantly share code, notes, and snippets.

@fairchild

fairchild/upgrade_heroku_pg.sh

Created December 13, 2014 00:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fairchild/35f1393648c598174ad4 to your computer and use it in GitHub Desktop.
Save fairchild/35f1393648c598174ad4 to your computer and use it in GitHub Desktop.
Download ZIP
example script to upgrade a heroku postgresql database
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment