gitea/compose.postgres.yml

version: '3.8'

services:
  app:
    environment:
      - GITEA_DB_TYPE=postgres
      - GITEA_DB_HOST="db:5432"
      - GITEA_DB_NAME=gitea
      - GITEA_DB_USER=gitea
  db:
    image: postgres:15.6
    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/backup.sql"
          backupbot.backup.post-hook: "rm -r /var/lib/postgresql/data/backup.sql"
          backupbot.backup.path: "/var/lib/postgresql/data"
    environment: 
      - POSTGRES_DB=gitea
      - POSTGRES_USER=gitea
      - POSTGRES_PASSWORD_FILE=/run/secrets/db_password
    secrets:
      - db_password
    volumes:
      - db:/var/lib/postgresql/data
    networks:
      - internal

secrets:
  db_password:
    name: ${STACK_NAME}_db_password_${SECRET_DB_PASSWORD_VERSION}
    external: true

volumes:
  db:
  internal: