60 lines
1.9 KiB
YAML
60 lines
1.9 KiB
YAML
---
|
|
version: "3.8"
|
|
|
|
x-postgres-env: &postgres-env
|
|
POSTGRES_DB: ${POSTGRES_DB:-tymeslot}
|
|
POSTGRES_USER: ${POSTGRES_USER:-tymeslot}
|
|
|
|
services:
|
|
app:
|
|
environment:
|
|
<<: *postgres-env
|
|
# Any DATABASE_HOST other than localhost puts start-docker.sh into external-database mode, which is what the slim image requires.
|
|
DATABASE_HOST: ${STACK_NAME}_db
|
|
DATABASE_PORT: 5432
|
|
secrets:
|
|
- postgres_password
|
|
|
|
db:
|
|
# Matches the version upstream's docker-compose.with-postgres.yml pins, and the version the bundled-database image variant creates its cluster with, so a data directory moved over from that image opens as-is.
|
|
image: ${DB_DOCKER_IMAGE:-postgres}:${DB_DOCKER_VERSION:-17-alpine}
|
|
# give Postgres time to shut down cleanly: the Swarm default (10s) force-kills it mid-shutdown on every redeploy, which wipes the cumulative stats (pg_stat_*) that autovacuum's triggers depend on
|
|
stop_grace_period: 2m
|
|
volumes:
|
|
- db-data:/var/lib/postgresql/data
|
|
networks:
|
|
- internal
|
|
environment:
|
|
<<: *postgres-env
|
|
POSTGRES_PASSWORD_FILE: /run/secrets/postgres_password
|
|
secrets:
|
|
- postgres_password
|
|
healthcheck:
|
|
test: ["CMD-SHELL", "pg_isready -h localhost -U $$POSTGRES_USER -d $$POSTGRES_DB"]
|
|
interval: 10s
|
|
timeout: 5s
|
|
retries: 5
|
|
deploy:
|
|
labels:
|
|
backupbot.backup: ${ENABLE_BACKUPS:-true}
|
|
backupbot.backup.pre-hook: "/pg_backup.sh backup"
|
|
backupbot.backup.volumes.db-data.path: "backup.sql"
|
|
backupbot.restore.post-hook: '/pg_backup.sh restore'
|
|
configs:
|
|
- source: pg_backup
|
|
target: /pg_backup.sh
|
|
mode: 0555
|
|
|
|
volumes:
|
|
db-data:
|
|
|
|
configs:
|
|
pg_backup:
|
|
name: ${STACK_NAME}_pg_backup_${PG_BACKUP_VERSION:-v1}
|
|
file: pg_backup.sh
|
|
|
|
secrets:
|
|
postgres_password:
|
|
external: true
|
|
name: ${STACK_NAME}_postgres_password_${SECRET_POSTGRES_PASSWORD_VERSION:-v1}
|