database connection refused

Question

My PostgreSQL runs under docker on port 5432.

docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS               NAMES
f7464f480dd3        postgres            "docker-entrypoint..."   6 hours ago         Up 3 minutes        5432/tcp            core_postgres

This is an official postgres container with some custom user and database created.

I'm using psycopg2 for connection:

import psycopg2
conn = "host='localhost' dbname='username' user='username' password='password'"
psycopg2.connect(conn)

But it raises:

Traceback (most recent call last):
  File "check_postgres.py", line 3, in <module>
    psycopg2.connect(conn)
  File "/Users/pivanchy/startup/venv/lib/python2.7/site-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

I've checked both: pg_hba.conf and postgresql.conf files and it looks like there is nothing strange there.

P.S. I can't also connect to this port via telnet:

telnet localhost 5432

Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host

What is wrong? My container is still running without errors in logs.

dvnguyen · Accepted Answer · 2018-01-07 18:53:52Z

1

You need to map a port of localhost to the port 5432 of the container with the -p option: docker run -p 5432:5432 [Other Options] postgres.

After that, the PORTS column in docker ps should show something like this: 0.0.0.0:5432->5432

answered Jan 7, 2018 at 18:53

dvnguyen

3,0301 gold badge19 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

database connection refused

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related