Can not connect PostgreSQL database from docker to python

Question

I am trying to use Postgresql with python. I have used the following docker compose the file.

version: '3.1'

services:

  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: admin_123
      POSTGRES_USER: admin

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080

With the following code, I am trying to connect with the database.

conn = psycopg2.connect(
    database = "db_test",
    user ="admin",
    password = "admin_123",
    host = "db"
)

But I am getting this error.

OperationalError: could not translate host name "db" to address: nodename nor servname provided, or not known

What I am doing wrong ?

Answer 1

You need to expose the BD port in the docker compose like this :

db:
image: postgres
restart: always
environment:
  POSTGRES_PASSWORD: admin_123
  POSTGRES_USER: admin
ports:
    - "5432:5432"

And then connect with localhost:5432