How do I change the billing app for my Heroku Postgres database?

Issue

I want to change the billing app for my Heroku Postgres database.

Resolution

Unfortunately, there currently isn't a way to change the billing app of add-ons to another app.

As a workaround, you can create a new database with a copy of the data and attach it to the app you want to set as the new billing app.

To do this, you can follow these steps:

  1. Create the new database with a copy of the data from the database on the current billing app and attach it to the other app (desired billing app)
$ heroku addons:create heroku-postgresql:<plan> --fork <current-billing-app-name>::DATABASE_URL --app <other-app>
  1. Run heroku pg:wait. Wait for this to say that the new database is ready.

  2. Promote the new database using heroku pg:promote -a other-app

If the above commands work successfully, you'll then have a working copy of all the data on an add-on that is billed to the desired app.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support