48 lines
1.3 KiB
YAML
48 lines
1.3 KiB
YAML
version: '3.8'
|
|
|
|
services:
|
|
app:
|
|
environment:
|
|
- POSTGRES_HOST=db
|
|
- POSTGRES_DB=nextcloud
|
|
- POSTGRES_USER=nextcloud
|
|
- POSTGRES_PASSWORD_FILE=/run/secrets/db_password
|
|
- NEXTCLOUD_UPDATE=1
|
|
|
|
db:
|
|
image: "pgautoupgrade/pgautoupgrade:14-debian"
|
|
#setting max_connections with -c breaks pgautoupgrade
|
|
#command: -c "max_connections=${MAX_DB_CONNECTIONS:-100}"
|
|
volumes:
|
|
- "postgres:/var/lib/postgresql/data"
|
|
networks:
|
|
- internal
|
|
environment:
|
|
POSTGRES_USER: nextcloud
|
|
POSTGRES_PASSWORD_FILE: /run/secrets/db_password
|
|
POSTGRES_DB: nextcloud
|
|
secrets:
|
|
- db_password
|
|
# The pgautoupgrade image already ships its own HEALTHCHECK.
|
|
# This runs pg_isready but also takes into accounts if pg_upgrade is being run.
|
|
# No need to override it here.
|
|
# healthcheck:
|
|
# test: ["CMD", "/usr/local/bin/pgautoupgrade-healthcheck.sh"]
|
|
deploy:
|
|
labels:
|
|
backupbot.backup.pre-hook: "/pg_backup.sh backup"
|
|
backupbot.backup.volumes.postgres.path: "backup.sql"
|
|
backupbot.restore.post-hook: '/pg_backup.sh restore'
|
|
configs:
|
|
- source: pg_backup
|
|
target: /pg_backup.sh
|
|
mode: 0555
|
|
|
|
volumes:
|
|
postgres:
|
|
|
|
configs:
|
|
pg_backup:
|
|
name: ${STACK_NAME}_pg_backup_${PG_BACKUP_VERSION}
|
|
file: pg_backup.sh
|