34 lines
757 B
YAML
34 lines
757 B
YAML
services:
|
|
postgres:
|
|
image: postgres:18
|
|
container_name: postgres_db
|
|
restart: unless-stopped
|
|
|
|
env_file:
|
|
- .env
|
|
|
|
environment:
|
|
# custom variables for init scripts (.sh)
|
|
APP_DB_USER: ${APP_DB_USER}
|
|
APP_DB_PASSWORD: ${APP_DB_PASSWORD}
|
|
|
|
ports:
|
|
- "${POSTGRES_PORT}:5432"
|
|
|
|
volumes:
|
|
- postgres_data:/var/lib/postgresql
|
|
- ./backup:/backup
|
|
#chmod +x init/01-roles.sh on linux?
|
|
- ./init:/docker-entrypoint-initdb.d
|
|
|
|
# if we need periodic backup
|
|
# entrypoint: >
|
|
# bash -c "while true; do
|
|
# pg_dump -h postgres -U ${POSTGRES_USER} ${POSTGRES_DB} > /backup/backup_$$(date +%Y%m%d_%H%M%S).sql;
|
|
# sleep 86400;
|
|
# done"
|
|
|
|
|
|
volumes:
|
|
postgres_data:
|