How do i connect my postgres db in heroku?

Question

I am learning rack and I built a test todo app. My test app uses postgres db. I am trying to deploy my app to heroku free account.

Currenlty I am trying to connect to postgres using this

DB = PG.connect :hostaddr => "localhost", :port => 5432, :dbname => 'testdb', :user => "postgres", :password => "postgres"

I checked my logs because my app was not workign when I visited the url and found out

2017-06-01T13:22:35.540907+00:00 app[web.1]: Puma starting in single mode...
2017-06-01T13:22:35.540929+00:00 app[web.1]: * Version 3.8.2 (ruby 2.3.4-p301), codename: Sassy Salamander
2017-06-01T13:22:35.540930+00:00 app[web.1]: * Min threads: 5, max threads: 5
2017-06-01T13:22:35.540975+00:00 app[web.1]: * Environment: production
2017-06-01T13:22:35.583653+00:00 app[web.1]: ! Unable to load application: PG::ConnectionBad: could not connect to server: Connection refused
2017-06-01T13:22:35.583655+00:00 app[web.1]:    Is the server running on host "127.0.0.1" and accepting
2017-06-01T13:22:35.583656+00:00 app[web.1]:    TCP/IP connections on port 5432?
2017-06-01T13:22:35.583775+00:00 app[web.1]: bundler: failed to load command: puma (/app/vendor/bundle/ruby/2.3.0/bin/puma)
2017-06-01T13:22:35.583838+00:00 app[web.1]: PG::ConnectionBad: could not connect to server: Connection refused
2017-06-01T13:22:35.583839+00:00 app[web.1]:    Is the server running on host "127.0.0.1" and accepting
2017-06-01T13:22:35.583840+00:00 app[web.1]:    TCP/IP connections on port 5432?

Edit 1

I found the postgres db creds in the heroku and used that and got this err

2017-06-01T14:27:11.889525+00:00 app[web.1]: Puma starting in single mode...
2017-06-01T14:27:11.889599+00:00 app[web.1]: * Version 3.8.2 (ruby 2.3.4-p301), codename: Sassy Salamander
2017-06-01T14:27:11.889633+00:00 app[web.1]: * Min threads: 5, max threads: 5
2017-06-01T14:27:11.889671+00:00 app[web.1]: * Environment: production
2017-06-01T14:27:11.934347+00:00 app[web.1]: ! Unable to load application: PG::ConnectionBad: could not translate host name "ec2-23-23-234-118.compute-1.amazonaws.com" to address: Name or service not known
2017-06-01T14:27:11.934473+00:00 app[web.1]: bundler: failed to load command: puma (/app/vendor/bundle/ruby/2.3.0/bin/puma)
2017-06-01T14:27:11.934522+00:00 app[web.1]: PG::ConnectionBad: could not translate host name "ec2-23-23-234-118.compute-1.amazonaws.com" to address: Name or service not known

DiegoSalazar · Accepted Answer · 2017-06-01 14:08:07Z

1

You can get your database config on Heroku from the DATABASE_URL environment variable:

ENV['DATABASE_URL']

That is a connection URL which looks like this:

postgres://$user:$pass@$db_host.com:5432/$db_name

You can pass that string directly to your PG client initializer:

DB = PG.connect ENV['DATABASE_URL']

DB is now your connected db client.

answered Jun 1, 2017 at 14:08

DiegoSalazar

13.5k2 gold badges42 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Raaz Over a year ago

Hi Diego , even after updating DB to DB = PG.connect ENV['DATABASE_URL'] still giving me PG::Connection Bad issue

DiegoSalazar Over a year ago

Looks like heroku may not have created your db yet. How did you create the heroku app and how did you deploy it? Do you have a Procfile? Please post these details in your question.

Raaz Over a year ago

Oh I have fixed it. DB = PG.connect ENV["HEROKU_POSTGRESQL_SILVER_URL"]

Raaz · Accepted Answer · 2017-06-01 15:13:40Z

0

Using this solved it DB = PG.connect ENV["HEROKU_POSTGRESQL_SILVER_URL"]

answered Jun 1, 2017 at 15:13

Raaz

1,7713 gold badges25 silver badges52 bronze badges

Collectives™ on Stack Overflow

How do i connect my postgres db in heroku?

Edit 1

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Edit 1

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related