Downgrading Heroku PG database
Accidentally I’ve provisioned paid plan for PG database. To downgrade such a database you need to:
# safety measures
heroku maintenance:on
# create a new database, new url will be given, for me it was: HEROKU_POSTGRESQL_ORANGE_URL
heroku addons:create heroku-postgresql:hobby-dev
# copy current db to ORANGE db
heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_ORANGE_URL
# make new database active
heroku pg:promote HEROKU_POSTGRESQL_ORANGE_URL
# ... and we are back
heroku maintenance:off
After promotion old database was renamed to PINK
then I removed it from heroku panel.
There is also other strategy for downgrade but it does not work for free plan: docs
Tweet