Step by step guide for Heroku Postgres upgrade, 9.5 to 9.6

steps.txt

Heroku DB upgrade notes

heroku addons:create heroku-postgresql:standard-0 -r production
heroku ps:scale web=0 worker=0 -r production
heroku maintenance:on -r production
heroku pg:backups:capture -r production
heroku pg:copy DATABASE_URL __NEW_DB_URL__ -r production
heroku pg:promote __NEW_DB_URL__ -r production
heroku ps:scale web=1 worker=1 -r production
heroku maintenance:off -r production
heroku pg:info -r production
heroku addons:destroy __OLD_DB_URL__ -r production
heroku pg:info -r production