Connect PGAdmin3 to Heroku PostgreSQL dedicated database

Viewed 2142

Match the data to the boxes for me, please. Here are the (doctored) results of running heroku config on my shiny new dedicated database:

=== Config Vars for myapp
DATABASE_URL:                postgres://thinga:thingb@ec2-23-21-119-36.compute-1.amazonaws.com:5432/thingc
GEM_PATH:                    vendor/bundle/ruby/1.9.1
HEROKU_POSTGRESQL_OLIVE_URL: postgres://thinga:thingb@ec2-23-21-119-36.compute-1.amazonaws.com:5432/thingc
HIREFIREAPP_TOKEN:           7965994a31ace96fc5f390longtoken
LANG:                        en_US.UTF-8
MEMCACHE_PASSWORD:           password
MEMCACHE_SERVERS:            mc9.ec2.northscale.net
MEMCACHE_USERNAME:           myapp%40heroku.com
PATH:                        vendor/bundle/ruby/1.9.1/bin:/usr/local/bin:/usr/bin:/bin:bin
PGBACKUPS_URL:               https://thing@pgbackups.heroku.com/client
RACK_ENV:                    production
RAILS_ENV:                   production

The fields for configuring a new server on my local PGAdmin3 are:

Name
Host
Port
Service
Maintenance DB
Username
Password
Group

What goes where?

1 Answers
Related