Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- version: '3.5'
- services:
- postgres:
- container_name: postgres_container
- image: postgres
- environment:
- POSTGRES_USER: ${POSTGRES_USER:-postgres}
- POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-changeme}
- PGDATA: /data/postgres
- volumes:
- - postgres:/data/postgres
- onrun:
- psql -h=localhost -P=${POSTGRES_PASSWORD} -U=${POSTGRES_USER} -tc "SELECT 1 FROM pg_database WHERE datname = 'premiership'" | grep -q 1 || psql -h=localhost -P=${POSTGRES_PASSWORD}-U=${POSTGRES_USER}c "CREATE DATABASE premiership"
- ports:
- - "5432:5432"
- networks:
- - postgres
- restart: unless-stopped
- volumes:
- - postgres:/data/postgres
- - ./initdb/1_schema.sql:/docker-entrypoint-initdb.d/1_schema.sql
- SELECT datname
- FROM pg_database
- WHERE datname='premiership'';
- IF datname='
- premiership'
- THEN CREATE DATABASE premiership PASSWORD 'test';
- END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement