Connect to a heroku database with pgadmin

database postgresql heroku pgadmin
Tomas Romero picture Tomas Romero · Aug 2, 2012 · Viewed 81.9k times · Source

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.

Any guide on how to achieve the connection?

Answer

araqnid picture araqnid · Aug 2, 2012

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.

pgAdmin III - New Server Registration

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.

Related questions

Change from SQLite to PostgreSQL in a fresh Rails project

I have a rails app that's databases are in SQLite (The dev and production). Since I am moving to heroku, I want to convert my database to PostgreSQL. Anyways, I heard that the local, development, database does not need to …

Read More
How do you write a case insensitive query for both MySQL and Postgres?

I'm running a MySQL database locally for development, but deploying to Heroku which uses Postgres. Heroku handles almost everything, but my case-insensitive Like statements become case sensitive. I could use iLike statements, but my local MySQL database can't handle that. …

Read More
PGError: ERROR: permission denied for relation (when using Heroku)

I've recently gone through the database migration process as outlined here: https://devcenter.heroku.com/articles/migrating-from-shared-database-to-heroku-postgres Now I'm seeing a number of errors in the logs like this: PGError: ERROR: permission denied for relation Any ideas on what I …

Read More