Heroku Database upgrade / update steps
- Create a follower
- Let follower catchup
- Check if follower is caught-up
heroku pg:info -a powr-staging - Upgrade follower database
heroku pg:upgrade FOLLOWER_DATABASE_NAME -a powr-staging - Note, when you upgrade, it will stop unfollowing and database becomes writable.
- Detach and re-attach new database
heroku addons:detach DATABASE -a powr-stagingheroku config:add DATABASE_URL=URL -a powr-staging
TODO: maintenence mode pg:wait for couple of mins (status update) wait couple of days before destroying old one