postgres:
image: postgres:alpine
ports:
- "5432:5432"
environment:
- POSTGRES_USER=root
- POSTGRES_PASSWORD=root
- POSTGRES_DB=postgres
restart: always
$ docker-compose up -d
$ docker-compose exec postgres psql -U root postgres
>>> SELECT CURRENT_TIMESTAMP;
now
-------------------------------
2016-12-07 01:44:29.872928+00
(1 row)
>>> \?
>>> \d
>>> \q