Upgrade Heroku-postgres Plan

  1. Enable maintenance mode

  2. Add new plan

1
heroku addons:create heroku-postgresql:hobby-basic --app APP_NAME
  1. Copy data from current db to the new one
1
heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_CYAN_URL --app APP_NAME

Note: DATABASE_URL and HEROKU_POSTGRESQL_CYAN_URL are heroku ENVs, run heroku config to check the detail.

  1. Select the new db as the default database
1
heroku pg:promote HEROKU_POSTGRESQL_CYAN_URL --app APP_NAME