How to install and run postgress using docker-compose.yml version "1"

Question

1: docker-compose.yml

postgres96:
  image: postgres:9.6
  ports:
    - "5432:5432"
  volumes:
    - ./Postgres/data:/var/lib/postgresql/data
  env:    
    POSTGRES_PASSWORD: admin@123
    POSTGRES_USER: postgres

2) $ docker-compose up &

postgres96_1      | LOG:  database system was not properly shut down; automatic recovery in progress
postgres96_1      | LOG:  invalid record length at 0/1570D50: wanted 24, got 0
postgres96_1      | LOG:  redo is not required
postgres96_1      | LOG:  MultiXact member wraparound protections are now enabled
postgres96_1      | LOG:  database system is ready to accept connections
postgres96_1      | LOG:  autovacuum launcher started

But while testing from pg-admin-iv on windows it show that 'user postgress has no password',

So is that flow from YML file is right, i want simply up the postgress and put data out side docker-container, so How to achieve this?

Answer 1

I would use named volumes for that instead of hosted mapped volumes:

postgres96:
  image: postgres:9.6
  ports:
    - "5432:5432"
  volumes:
    - data:/var/lib/postgresql/data
  environment:    
    POSTGRES_PASSWORD: admin@123
    POSTGRES_USER: postgres

Probably you have a permission issue in your folder.

You data is saved in a volume outside the container. Then check with:

docker volume ls

Also use docker-compose as:

docker-compose up -d

Instead of &

And

docker-compose logs -f

For further information this is the last part of my log:

postgres96_1  | PostgreSQL init process complete; ready for start up.
postgres96_1  |
postgres96_1  | LOG:  database system was shut down at 2016-11-14 21:05:51 UTC
postgres96_1  | LOG:  MultiXact member wraparound protections are now enabled
postgres96_1  | LOG:  database system is ready to accept connections
postgres96_1  | LOG:  autovacuum launcher started
postgres96_1  | LOG:  incomplete startup packet

Regards