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
Master Core Java, JSP, Servlet, Hibernate, Maven, Spring, and more with our comprehensive tutorials and guides. Start learning today!