grist/compose.postgres.yml
2024-07-05 18:39:03 +02:00

40 lines
1.0 KiB
YAML

services:
app:
environment:
- TYPEORM_DATABASE=grist
- TYPEORM_TYPE=postgres
- TYPEORM_USERNAME=grist
- TYPEORM_PASSWORD_FILE=/run/secrets/db_password
- TYPEORM_HOST=db
depends_on:
- db
secrets:
- db_password
db:
image: postgres:13
networks:
- internal
secrets:
- db_password
volumes:
- 'postgresql_data:/var/lib/postgresql/data'
environment:
- POSTGRES_USER=grist
- POSTGRES_DB=grist
- POSTGRES_PASSWORD_FILE=/run/secrets/db_password
deploy:
labels:
backupbot.backup: "true"
backupbot.backup.pre-hook: "PGPASSWORD=$$(cat $${POSTGRES_PASSWORD_FILE}) pg_dump -U $${POSTGRES_USER} $${POSTGRES_DB} > /var/lib/postgresql/data/postgres-backup.sql"
backupbot.backup.post-hook: "rm -rf /var/lib/postgresql/data/postgres-backup.sql"
backupbot.backup.path: "/var/lib/postgresql/data/"
secrets:
db_password:
external: true
name: ${STACK_NAME}_db_password_${SECRET_DB_PASSWORD_VERSION}
volumes:
postgresql_data: