Skip to content

Instantly share code, notes, and snippets.

@josiasds
Created March 11, 2014 01:15
Show Gist options
  • Save josiasds/9477716 to your computer and use it in GitHub Desktop.
Save josiasds/9477716 to your computer and use it in GitHub Desktop.
Heroku Postgres Upgrade in production
heroku addons:add pgbackups
heroku addons:add heroku-postgresql:hobby-basic
# The new database color will be created. Ex.: HEROKU_POSTGRESQL_IVORY
heroku maintenance:on
heroku ps:scale worker=0
heroku pgbackups:transfer HEROKU_POSTGRESQL_IVORY
heroku pg:promote HEROKU_POSTGRESQL_IVORY
heroku ps:scale worker=1
heroku maintenance:off
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment