Django cannot connect to postgresql docker container

Question

I have a postgres db running in a docker container:

my docker-compose:

version: "3"
services:
  db:
    image: postgres:13.1-alpine
    environment:
      - POSTGRES_DB=mydb
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=test
    ports:
      - "5432:5432"
    volumes:
      - ./postgres_data:/var/lib/postgresql/data/

Django running on the host machine (ubuntu linux, not in the docker container) cannot connect to it.

django's settings.py:

    DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'HOST' : "localhost",
        'NAME' : "mydb",
        'USER' : "postgres",
        'PASSWORD' : "test",
        'PORT':5432,
    }
}

Exception:

django.db.utils.OperationalError: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

Database is certainly avaliable on port 5432(I can connect to it with dbeaver database client on localhost:5432).

What could be the cause of the problem?

Ivonet · Accepted Answer · 2021-05-21 13:35:46Z

1

Access it as HOST=db in stead of localhost assuming that the django is also contained in the docker-compose.yml

This is because in your docker-compose the database "service" name is db and therefore its "DNS" name will be db within the docker-compose created network.

answered May 21, 2021 at 13:35

Ivonet

2,7502 gold badges20 silver badges31 bronze badges

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

5 Comments

Hello Over a year ago

I need to connect from the host machine. From the container it connects no problem

Ivonet Over a year ago

Then the question is of you are running from mac/linux or windows? if you are using docker-machine the IP address can be found with docker-machine ip default otherwise I would expect localhost to be working...

Hello Over a year ago

Running on linux. Not using docker-machine. It's super confusing since other apps can connect

Ivonet Over a year ago

does this one help? stackoverflow.com/questions/29937378/…

Hello Over a year ago

Nope, didn't help. My uneducated guess is psycopg2 somehow hardcoded to look for postgres server running directly on the host, not in the container connected to a port..

Hello · Accepted Answer · 2021-05-21 14:42:24Z

-3

figured it out, just had an error in settings.py connection values

answered May 21, 2021 at 14:42

Hello

752 silver badges6 bronze badges

Collectives™ on Stack Overflow

Django cannot connect to postgresql docker container

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related