Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connect PGAdmin3 to Heroku PostgreSQL dedicated database

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:[email protected]:5432/thingc
GEM_PATH:                    vendor/bundle/ruby/1.9.1
HEROKU_POSTGRESQL_OLIVE_URL: postgres://thinga:[email protected]: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://[email protected]/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?

like image 483
snowangel Avatar asked Aug 18 '12 08:08

snowangel


People also ask

How do I connect to a Postgres database in pgAdmin?

To access a database in the pgAdmin browser, expand Servers, the DB instance, and Databases. Choose the DB instance's database name. To open a panel where you can enter SQL commands, choose Tools, Query Tool.


1 Answers

OK: everything comes from the database URL.

DATABASE_URL:                postgres://thinga:[email protected]:5432/thingc


Name: thingc
Host: ec2-23-21-119-36.compute-1.amazonaws.com
Port: 5432
Service
Maintenance DB: thingc
Username: thinga
Password: thingb
Group
like image 106
snowangel Avatar answered Oct 11 '22 14:10

snowangel