'How to automatically create a separate Heroku Postgres for each Review App?

I have a Heroku pipeline with a separate app for the staging environment (develop branch) and a separate app for the production environment. Each of the environment apps has its own database enabled through Heroku Postgres (DATABASE_URL is unique for the environment). I also have enabled Review Apps – temporary apps for pull requests, which allows me to review the changes "in action" before merging them to develop.

pipeline outline

However, these temporary apps do not have any database attached to them. I want to have separate independent instances of Heroku Postgres created for each temporary app automatically; ideally, on subsequent redeployments, it would also be cleaned up or destroyed and created again from scratch. Is this possible?

Also, do I need app.json to do this? I'm not strictly against having it, but the whole setup so far has been made through Heroku UI, which is fun to use, and I would prefer to keep it that way.

postgresqlherokucontinuous-integration


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions