Connect to a heroku database with pgadmin
database, heroku, pgadmin, postgresql
Solution
Open the "Properties" of the Heroku server in pgAdminIII and change the "Maintenance DB" value to be the name of the database you want to connect to.
The default setup is suitable for DBAs et al who can connect to any database on the server, but apparently that isn't true in your case.
Problem
I would like to manage my Heroku database with `pgadmin` client. By now, I've been doing this with `psql`. When I use data from `heroku pg:credentials` to connect de DB using `pgadmin`, I obtain: An error has occurred: Error connecting to the server: FATAL: permission denied for database "postgres" DETAIL: User does not have CONNECT privilege. How to achieve the connection?