create a user in postgres docker container

Question

I am trying to create a django app in docker container, but I do not know how to create a user in postgres container that django uses. I guess that is why when I start it (by docker-compose up --build --force-recreate) it tells me database_1 | FATAL: role "my_user" does not exist. What am I doing wrong?

docker-compose.yaml right now looks like:

version: "3.1"
services:

  database:
    image: postgres:9.5
    environment:
      POSTGRES_DB: "django_db"
      POSTGRES_USER: "my_user"
      POSTGRES_PASSWORD: "my_password"
      POSTGRES_DATA: /var/lib/postgresql/data/pgdata
    logging:
      options:
        max-size: "10m"
        max-file: "3"
    restart: always
    volumes:
      - "database:/var/lib/postgresql/data"
    tmpfs:
      - "/tmp"
      - "/run"
    networks:
      db-net:

  django:
    build: ./
    image: django:latest
    environment:
      DATABASE_URL: "postgres://my_user:my_pass@database/django_db"

    ports:
      - 7445:80

try to clean /var/lib/postgresql/data directory and restart cluster. — Bukharov Sergey
– Bukharov Sergey, Commented Oct 10, 2017 at 15:02
Your services might be starting at the same time so django tries to connect before the progres database created the user. docs.docker.com/compose/startup-order — JodyT
– JodyT, Commented Oct 10, 2017 at 15:04

Yannic Hamann · Accepted Answer · 2017-10-10 17:44:59Z

3

From your docker-compose.yml I would say that you have successfully created the user my_user in your database. You can verify that by running docker exec -ti project_database_1 psql -U my_user -d django_db on your host.

I suggest you take a look at cookiecutter-django. You can find there a complete docker setup including the solved problem JodyT mentioned about starting Django before the postgres container is actually ready.

It's from the authors of the book two scopes of django which is also worth a read.

edited Oct 10, 2017 at 17:44

answered Oct 10, 2017 at 17:35

Yannic Hamann

5,2651 gold badge37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

create a user in postgres docker container

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related