© 2013 All rights reserved.

Remote connection to heroku (Postgre sql) database

How to easily connect to PostgreSQL, hosted on Heroku, with pgAdmin.

All you need are own login data to database. There are two ways to obtain this:


1. From the web interface Heroku.


After logging in you can see a list of data, including password.




2. From heroku command line:


After logging in you can get credentials from heroku heroku pg


Login to heroku:


Get list of databases


Get credentials from heroku database


heroku pg:credentials return full connection string.



Comments are closed for this page

Hi, i am programmer from the Czech Republic. I love web development (Ruby, Ruby on Rails, PHP, Nette) and iOS development (Objective-C, Cocoa).
To cooperate, here is my phone:
+420 608 836