Docker compose to setup database

database.env

POSTGRES_USER=unicorn_user
POSTGRES_PASSWORD=magical_password
POSTGRES_DB=modern_api

docker-compose.yaml

version: '3'

services:
  database:
    image: 'postgres'
    restart: always
    ports:
      - "5432:5432"
    env_file:
      - ./env/database.env
    networks:
      - my_network
    volumes:
      - database-data:/var/lib/postgresql/data/
      - ./ops/init.sql:/docker-entrypoint-initdb.d/docker_postgres_init.sql
volumes:
  database-data:
networks:
  my_network:
    driver: bridge

init.sql

SELECT current_database();

CREATE TABLE increment (
	counter_key VARCHAR ( 250 ) PRIMARY KEY,
	counter_value int NOT null
);