postgres and docker-compose : can't create a custom role and database

Question

I'am trying to create a simple postgreSQL container with a custum user and database.

This is my docker-compose file :

version: '2'
services:
  db.postgres:
    container_name: db.postgres
    image: postgres:10
    environment:
      - POSTGRES_USER:'myuser'
      - POSTGRES_PASSWORD:'myuserpassword'
      - POSTGRES_DB:'mydb'
    ports:
      - '5432:5432'
    volumes:
      - ./pgdata:/var/lib/postgresql/data

And the error when I try to connect to my database.

docker exec -it db.postgres psql -U myuser myuserpassword
psql: FATAL:  role "myuser" does not exist

OR

$ docker exec -it db.postgres /bin/bash
root@1a0531e0350f:/# psql -U myuser
psql: FATAL:  role "myuser" does not exist

Docker-compose environment variables appear to be ignored when creating the database.

I don't known what can I do. Do you have an idea of the problem?

Thanks !

Yuankun · Accepted Answer · 2018-03-05 14:50:28Z

15

Modify your docker-compose.yml file as below:

version: '2'
services:
  db.postgres:
    container_name: db.postgres
    image: postgres:10
    environment:
      - POSTGRES_USER=myuser
      - POSTGRES_PASSWORD=myuserpassword
      - POSTGRES_DB=mydb
    ports:
      - '5432:5432'
    volumes:
      - ./pgdata:/var/lib/postgresql/data

Then drop your current data entirely and re-run docker-compose up.

answered Mar 5, 2018 at 14:50

Yuankun

7,9394 gold badges34 silver badges34 bronze badges

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

3 Comments

zlacheman Over a year ago

Thanks ! but I don't undestand on lot of documentation they use the notation "ENV_VAR: value" for example : hub.docker.com/_/postgres or docs.docker.com/samples/library/postgres/…

Vikas Pal Over a year ago

I had to remove the docker volume for postgres github.com/docker-library/postgres/issues/…

vpalmerini Over a year ago

You either use - VAR=value or VAR: value

Collectives™ on Stack Overflow

postgres and docker-compose : can't create a custom role and database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related