Skip to content

Instantly share code, notes, and snippets.

@ewalk153

ewalk153/upgrade_postgres.bash

Created January 3, 2014 03:32
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ewalk153/8232216 to your computer and use it in GitHub Desktop.
Save ewalk153/8232216 to your computer and use it in GitHub Desktop.
Download ZIP
upgrade heroku postgres from crane to yanari
Raw
upgrade_postgres.bash
# this can be done anytime
heroku addons:add heroku-postgresql:standard-yanari --app nav-chronos; heroku pg:wait
# about 3m30s
heroku maintenance:on
heroku ps:scale worker=0
heroku pgbackups:capture --expire
# less than 20 min
heroku pgbackups:restore HEROKU_POSTGRESQL_PINK
# less than 20 min
heroku pg:promote HEROKU_POSTGRESQL_PINK
heroku maintenance:off
heroku ps:scale worker=1
# destroy old database once your sure the new database is working
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment