version: "3.9"
services:
postgres:
image: postgres:latest
container_name: postgres
environment:
POSTGRES_PASSWORD: "123"
MAX_CONNECTION: 200
PGDATA: "/var/lib/postgresql/data/pgdata"
ports:
- "5432:5432"
volumes:
- type: bind
source: /opt/docker_postgres/postgres_data
target: /var/lib/postgresql/data/
#!/bin/bash
set -e
psql -v ON_ERROR_STOP=1 --username postgres --dbname 123 <<-EOSQL
CREATE USER user WITH PASSWORD 321;
CREATE DATABASE userdb;
GRANT ALL PRIVILEGES ON DATABASE userdb TO user;
EOSQL