My name is Dave Stanton

< Home

Getting Started with PostgreSQL on Heroku



Heroku provides free, managed PostgreSQL databases.



  1. Create Heroku account
    1. Go to ( and signup if you do not have an account
    2. Show the menu and describe elements
      1. add-ons
      2. buttons
      3. build packs
    3. Return to the dashboard
  2. Create Heroku app
    1. Confirm customer-project-stage is available for customer-project, customer-project-develop, and customer-project-staging
    2. We’re not going to do anything related to the app itself yet
  3. Create PostgreSQL database add-on
    1. Add PostgreSQL
    2. Click in and wait for health check to pass
  4. Connect to PostgreSQL database with a SQL client
    1. Create a new connection

Next post in this series

Creating the Database