How do I connect to my heroku shared database for postgresql?

Question

I have pulled the SHARED_DATABASE_URL from heroku config

SHARED_DATABASE_URL => postgres://username:[email protected]/db_name

I am using pgAdmin to try to connect to it but it keeps on timing out. Do I need to specify a port? What am i missing?

Answer 1

You can use this command to connect to psql.

heroku pg:psql

Answer 2

If you are happy to change to postgres 9.1 you can use the newly launched development database, which permits connections via normal postgres tools. Read more at https://postgres.heroku.com/blog/past/2012/4/26/heroku_postgres_development_plan/