PostgreSQL with docker compose and sqlalchemy

Question

Hey im trying to create a postgresql db container, im running it using the command:

docker-compose up

on the following compose file:

version: '3.1'
services:

  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_USERNAME: admin
      POSTGRES_PASSWORD: admin
      POSTGRES_DB: default_db
    ports:
      - 54320:5432

However when I try to connect to it using the follwoing python code:

import sqlalchemy
engine = sqlalchemy.create_engine('postgres://admin:admin@localhost:54320/default_db')
engine.connect()

I get the following error:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  password authentication failed for user "admin"

Anyone knows why this happens?

How is your postgres authentication configured? It appears that the client library is able to access Postgres, but not to authenticate. Try starting the containers, then doingdocker exec -it <postgres-container-id> /bin/sh, and try to connect to Postgres from within the container. — 9000
– 9000, Commented Sep 20, 2019 at 18:31

Omri Shneor · Accepted Answer · 2019-09-20 19:50:55Z

2

Using POSTGRES_USER instead of POSTGRES_USERNAME solved this for me.

answered Sep 20, 2019 at 19:50

Omri Shneor

1,0253 gold badges21 silver badges36 bronze badges

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

Comments

Yong Wang · Accepted Answer · 2019-09-21 13:12:24Z

1

You should use POSTGRES_USER instead of POSTGRES_USERNAME.

Here is my postgres docker-compose configuration for your reference.

version: '3'
services:
    postgres:
        image: 'mdillon/postgis:latest'
        environment:
            - TZ=Asia/Shanghai
            - POSTGRES_USER=postgres
            - POSTGRES_PASSWOR=postgres
        ports:
            - '15432:5432'

answered Sep 21, 2019 at 13:12

Yong Wang

1,31311 silver badges15 bronze badges

Collectives™ on Stack Overflow

PostgreSQL with docker compose and sqlalchemy

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related