Heroku – How to Deploy Postgres Add-Ons?

Recently I was helping one of my clients on Comprehensive Database Performance Health Check, they asked me if I know how to Deploy Postgres Add-Ons on Heroku. While during the consulting engagement I like to focus on SQL Server Performance Tuning, I do not mind helping my client with any other issues they are facing if I know the answer. Let me explain with the help of images how one can install Postgres Add-Ons on the Heroku app.

Heroku - How to Deploy Postgres Add-Ons? herokupostgres-800x471

First login to your Heroku Platform over here and follow the direction provided by the images.

Deploying Heroku Postgres

Heroku - How to Deploy Postgres Add-Ons? herokuapp1

Heroku - How to Deploy Postgres Add-Ons? herokuapp2

Heroku - How to Deploy Postgres Add-Ons? herokuapp3

Heroku - How to Deploy Postgres Add-Ons? herokuapp4

Heroku - How to Deploy Postgres Add-Ons? herokuapp5

Heroku - How to Deploy Postgres Add-Ons? herokuapp6

Heroku - How to Deploy Postgres Add-Ons? herokuapp7

Heroku - How to Deploy Postgres Add-Ons? herokuapp8

Heroku - How to Deploy Postgres Add-Ons? herokuapp9

Well, that’s it. You can follow all the images and create a new application in your Heroku Platform and as well as add new Postgres add-ons to the platform. Once the Postgress is added to your application, you can connect to it with the credentials displayed on the screen.

I hope this quick tutorial will help you to get started with the Postgres on Heroku.

Postgres Learning Path on Pluralsight

If you want to learn Postgres, here is the learning path of the Postgres available on Pluralsight.

Reference: Pinal Dave (https://blog.sqlauthority.com) 

Heroku, PostgreSQL
Previous Post
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
Next Post
SQL SERVER – Storing a Non-English String in Table – Unicode Strings

Related Posts

Leave a Reply