I created a Premium-2 Heroku database following the production Premium-0 database.
This is the script to run tonight to finalize the upgrade:
[x] Turn on maintenance mode:
heroku maintenance:on -a production-1
[x] Unfollow the current production database
heroku pg:unfollow HEROKU_POSTGRESQL_RED_URL -a production-1
[x] Promote the new database to be the primary database used by production
heroku pg:promote HEROKU_POSTGRESQL_RED -a production-1
[x] Verify that the environment DATABASE_URL now points to HEROKU_POSTGRESQL_RED_URL
heroku config -a production-1
heroku pg:info -a production-1
[x] Restart all dynos for changes to take effect
heroku dynos:restart -a production-1
[x] Disable maintenance mode
heroku maintenance:off -a production-1
We should probably keep the old database around for a few days for safety, but also verify that it remains at zero connections and zero writes during that time.
I created a Premium-2 Heroku database following the production Premium-0 database.
This is the script to run tonight to finalize the upgrade:
DATABASE_URL
now points to HEROKU_POSTGRESQL_RED_URLWe should probably keep the old database around for a few days for safety, but also verify that it remains at zero connections and zero writes during that time.