PostgreSQLÂ is an advanced open source relational database management system ( RDBMS ). It is powerful and cost-effective and a go-to solution for many companies that need to collect their data.
What is Heroku
Heroku is a cloud platform as a service (Paas) that lets companies build, deliver, monitor and scale apps. It provides a simple easy to use platform for developers to deploy their apps to market easily.
What is Heroku Postgres?
Heroku offers a free plan for hosting PostgreSQL databases. Heroku Postgres is a managed SQL database service provided by Heroku based on PostgreSQL. With built in easy set-up, database forking, security and etc., developers can focus on building their application instead of messing around with database management.
How to setup Heroku Postgres?
Setting up a Postgres in Heroku is pretty straight forward.
Sign up for free Heroku account
Sign up for a free account here
1. Click on the menu dropdown on your right and select Dashboard.
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-1024x262.png)
2. Click on New menu dropdown and select Create new app.
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-1-1024x265.png)
3. Install Heroku Postgres as add-on here and click Install Heroku Postgres button
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-2-1024x326.png)
4. Select Add on plan and select the app that you have just created at step 2 for App to provision to.
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-3-1024x415.png)
5. Go back to your account and click on the menu and select Data and click on the database name created.
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-4-1024x253.png)
6. Navigate to Settings and click on View Credentials
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-6-1024x403.png)
This is where you will find the credential you need for database connection
![](https://thegreenbrain.com.au/blog/wp-content/uploads/2020/07/image-7-1024x397.png)
Click on Next to see how to connect Heroku database with pgadmin
client