Skip to main content

Posts

Showing posts with the label Postgresql

How to connect pgAdmin to heroku postgresql

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