© 2013 All rights reserved.
0

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.

 



heroku

 

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.

 



heroku

Comments (0)

No comments yet, but you can be the first..

Add comment

About
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