Step 2 (Heroku): Setup Heroku Postgres

This guide is about how to setup a Postgres database in Heroku.

What is Heroku?

Heroku is a cloud platform that lets companies build, deliver, monitor and scale apps — we’re the fastest way to go from idea to URL, bypassing all those infrastructure headaches.

What is Heroku Postgres?

Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.

How to setup Heroku Postgres?

Setting up a Postgres in Heroku is pretty straight forward.

Go to your Heroku account

If you have an account in Heroku, you can log in here. If you need to setup a new one go here. They also offer a free tier.

1. Click to the Dashboard menu dropdown on your left.

2. Select Databases.

Heroku Postgres Setup

Heroku Postgres Setup – Start here

3.  Click Create Database in the top right-hand corner.

Heroku Postgres Setup

Heroku Postgres Setup

4. A modal will pop-up with the pricing plans. It ranges from free to more expensive plans with ultimate performance and storage. The selection mainly has to do with your use case. Select your Plan, select a Region and when done, click Add Database.

Heroku Postgres Setup

Heroku Postgres Setup – Pricing

5. Wait for the database provisioning to complete. After a while, the database should show it into Available state.

Heroku Postgres Setup

Heroku Postgres Setup

6. Click on your newly created database to see its overview. We will need these settings for setting up the connection with Blendo.

Heroku Postgres Setup

Heroku Postgres Settings

Next Steps:

In the next section we will see how to connect your Heroku Postgres to Blendo in order to send your data.

READ NEXT: Step 3: How to connect to Heroku PostgreSQL as a Data Warehouse Integration.

Questions? Contact us!

in PostgreSQL