Connect to Postgres running on docker with pyodbc

Question

trying to connect to a Postgres database inside docker but having the following problem:

File "", line 1, in pyodbc.OperationalError: ('08001', '[08001] could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"?\n (101) (SQLDriverConnect)')

The connection is being established with the following:

conn_str = ("DRIVER=/usr/local/lib/psqlodbcw.so;""DATABASE=mytestdb;""UID=postgres;""PWD=mysecretpassword""SERVER=localhost;""PORT=5432;");

conn = pyodbc.connect(conn_str)

trying to connect to a Postgres database inside docker did the application that trying to connect inside a docker instance or on the host OS? also, on your connection string it says localhost (SERVER=localhost), you might want to see the ip of your docker instance, otherwise setup a NAT for the docker.. — Bagus Tesa
– Bagus Tesa, Commented Mar 25, 2019 at 1:11
Thanks for this, I just checked that the container IP was 172.17.0.2 and changed it on the code but still got the same issue. — Talles
– Talles, Commented Mar 25, 2019 at 1:22
is the host had the same subnet address with that IP? something like 172.17.0.1? if you have pgAdmin, you may want to connect it first. also just a side note, do you have any third party anti virus or firewall? that can also be the cause your host unable to communicate with the docker instance. — Bagus Tesa
– Bagus Tesa, Commented Mar 25, 2019 at 2:23

Eddwin Paz · Accepted Answer · 2019-03-25 01:04:08Z

2

Make sure on your docker container you expose port 5432 other wise you wont be able to connect. This information can clear your thoughts. https://medium.com/@lvthillo/connect-from-local-machine-to-postgresql-docker-container-f785f00461a7

on your docker-compose.yml change it to something like this:

db:
image: postgres
ports:
  - 5432:5432

it can be 5432 or 5435 if you already have pg on your local machine.

answered Mar 25, 2019 at 1:04

Eddwin Paz

2,8885 gold badges32 silver badges53 bronze badges

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

2 Comments

Talles Over a year ago

I followed those steps (used that post as reference). I also changed the SERVER to SERVER=172.17.0.2 since that's the container IP but I still got the same error.

Eddwin Paz Over a year ago

you need to change you config to allow remote address to connect. did you do that? also do not use IP simply use db or the name of your image.

Thanh Nguyen Van · Accepted Answer · 2019-03-25 03:03:13Z

0

Your application is trying to connect postgres via unix socket file in host /tmp/ folder.

So configure mount point for docker container in posgres docker-compose file as below:

volumes:
      - /tmp:/var/lib/postgresql

then rebuild postgres container again.

answered Mar 25, 2019 at 3:03

Thanh Nguyen Van

12k8 gold badges41 silver badges58 bronze badges

Collectives™ on Stack Overflow

Connect to Postgres running on docker with pyodbc

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related