[Fixed]-Psycopg2 cannot connect to docker image

7๐Ÿ‘

As per psycopg2โ€™s documentation. If the host value is empty then by default it will look for the Unix Socket file of Postgres.

And in your error message, it is mentioned that it is looking for the socket file (.s.PGSQL.5432) under the tmp directory.

If you are running postgres as a seperate container, then you can find out this socket file under /var/run/postgresql directory in your container.

You can mount this folder to your host like below:

docker run -e POSTGRES_PASSWORD=mysecretpassword -v /home/username/socket_dir:/var/run/postgresql -d postgres

then you can update your DATABASE object like below:

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': 'fnf',
        'USER': 'fnfuser',
        'PASSWORD': 'fnf2pwd',
        'host': '/home/username/socket_dir/',
        'port': 5432,

Now the connection should be established.

๐Ÿ‘คThilak

1๐Ÿ‘

There is a difference between your Pycharm and your Django settings.

Pycharm explicitely connects to localhost when Django setting is trying to connect to ''.

Simply putting 'localhost' as your HOST Django setting should work.

Please note that the correct setting names are uppercase HOST and PORT, not lower case host and port.

๐Ÿ‘คTryph

1๐Ÿ‘

You should provide name of postgresql docker container as value to host key:

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': 'fnf',
        'USER': 'fnfuser',
        'PASSWORD': 'fnf2pwd',
        'HOST': 'fnf-postgis', # Name of postgres docker container
        'PORT': 5432, # Its exposed port
    }
}
๐Ÿ‘คnrgx

Leave a comment