Postgresql DB not getting connected in docker

Question

My rails application is running in docker. I am having my server running and listening on host 'localhost' and port 3000. But when I hit the browser with 'http://localhost:3000/' I get the below error-

PG::ConnectionBad at /

could not connect to server: Connection timed out Is the server running on host "db" (184.168.221.24) and accepting TCP/IP connections on port 5432?

I am unable to find out from where this '184.168.221.24' IP is coming. Thanks.

Do you start your containers via compose? This looks like you have a linked db container. Containers run on a virtual network on your machine — fishi0x01
– fishi0x01, Commented Jun 27, 2017 at 10:07
Well it looks like your db container is either not starting up properly or not allowing connnections from your app container. Can you verify that your db container is running (docker ps). And did you expose port 5432 on your db container? — fishi0x01
– fishi0x01, Commented Jun 27, 2017 at 10:14

Mayur Shah · Accepted Answer · 2017-06-27 11:37:23Z

1

Try this one

docker restart container-name

sudo service postgresql restart

This will restart your PostgreSQL, hope this will be helpful for you.

edited Jun 27, 2017 at 11:37

answered Jun 27, 2017 at 10:06

Mayur Shah

3,4571 gold badge24 silver badges44 bronze badges

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

14 Comments

Harshwardhan Singh Rathore Over a year ago

got this postgresql: unrecognized service

Mayur Shah Over a year ago

try this sudo yum install postgresql-server

fishi0x01 Over a year ago

No he wants to run it in a compose stack. Not install it on a local machine

Harshwardhan Singh Rathore Over a year ago

Hey Mayur, when I run this 'psql --version', I got this 'psql (Postgres-XC) 1.1 (based on PostgreSQL) 9.2.4'. That means postgresql-server is installed on my machine. Right?

Mayur Shah Over a year ago

What about restarting docker-machine restart dev or boot2docker stop boot2docker start

|

fishi0x01 · Accepted Answer · 2017-06-27 10:16:56Z

0

As I already mentioned in the comments, it looks like your db container is either not starting up properly or not allowing connections from your app container. Verify that your db container is running (docker ps). Further, ensure that you expose port 5432 on your db container to other containers in your compose stack.

answered Jun 27, 2017 at 10:16

fishi0x01

3,80924 silver badges27 bronze badges

4 Comments

Harshwardhan Singh Rathore Over a year ago

DB container is running with image - mdillon/postgis:9.6

fishi0x01 Over a year ago

Then it is most likely because port 5432 is not exposed. You can use expose: 5432 in your compose yaml to open it to linked containers. Docu

Harshwardhan Singh Rathore Over a year ago

This is what I am having in docker-compose.yml file- db: image: mdillon/postgis:9.6 ports: - '5433:5432'

Harshwardhan Singh Rathore Over a year ago

Any other way to expose: 5432 ?

Collectives™ on Stack Overflow

Postgresql DB not getting connected in docker

2 Answers 2

14 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

14 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related