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