DB, user not created using postgres docker-compose

user_5594493 0
Viewed 1537

I was setting up my django project and postgres but everytime I was getting this error

role doesn't exist

or

Db doesn't exist

So when I only tried to setup postgres and see if postgres is creating user and db correctly, but it wasn't

Here is my docker compose file : 

    version: "3"
        services:
          templates_db:
            image: postgres:9.6
            ports:
             - "5432:5432"
            environment:
              - POSTGRES_USER=my_user
              - POSTGRES_PASSWORD=my_pass
              - POSTGRES_DB=my_db
            volumes:
              - ./data/postgres:/var/lib/postgresql/data

I ran my compose file using docker-compose up --build and got below logs 

    templates_db_1  | LOG:  database system was interrupted; last known up at 2017-05-16 05:48:39 UTC
    templates_db_1  | LOG:  database system was not properly shut down; automatic recovery in progress
    templates_db_1  | LOG:  invalid record length at 0/14F0080: wanted 24, got 0
    templates_db_1  | LOG:  redo is not required
    templates_db_1  | LOG:  MultiXact member wraparound protections are now enabled
    templates_db_1  | LOG:  database system is ready to accept connections
    templates_db_1  | LOG:  autovacuum launcher started

  • When I logged into postgres shell as 

    docker exec -it **container_id** sh
su - postgres
$ psql
postgres=# \l

It didn't have the db I mentioned in compose file my_db

docker-compose docker postgresql
1 Answers

I had the same issue but my problem was that I had also installed POSTGRESSQL itself.

This was caching more than it needed too and also interfering with user and password validation. After de-installing POSTGRESSQL itself, docker-compose down -v && docker-compose up -d, run application and it worked swimmingly.

user_140662140
Related