1.first of all you need to go to https://postgres.heroku.com/databases and click on the database you want to connect with.
2.And copy the host, database, name ,user,port,password .
3.Now open pgAdminIII client and click on add connection to servers button and paste the credential copied from the heroku ; maintenance DB referrers to database name.
4. Then in the "Advanced" tab you must enter the maintenance DB name(Database name) surrounded with a single quotes.
eg: 'dbname'
5.After that click on "ok" button done....!!!!
for further reference go to following links :
Connect to a heroku database with pgadmin
heroku postgresql How to hide databases that i am not allowed to access
very good details
ReplyDeletewebsite application developer