postgresql - Connect to a heroku database with pgadmin

Question

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?

Answer 1

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.