version: '3.3'

volumes:
  postgresql_data:
  postgresql_init:
  postgresql_backup:
  postgresql_backup_logs:

networks:
  database:
    internal: true

secrets:
  testpgbackup_postgres_password:
    external: true

configs:
  test_db_sql:
    file: ./test.sql

services:
  postgresql:
    image: postgres:9.6-alpine
    volumes:
      - postgresql_data:/var/lib/postgresql/data
      - postgresql_init:/docker-entrypoint-initdb.d
    networks:
      - database
    configs:
      - source: test_db_sql
        target: /docker-entrypoint-initdb.d/test.sql
    secrets:
      - source: testpgbackup_postgres_password
        target: postgres_password
        mode: 0440
        uid: '70' #postgres
        gid: '70' #postgres
    environment:
      POSTGRES_USER: testdbuser
      POSTGRES_DB: testdb
      PGDATA: /var/lib/postgresql/data/pgdata
      POSTGRES_INITDB_ARGS: --pwfile=/run/secrets/postgres_password

  pgbackup:
    image: postgresbup
    volumes:
      - postgresql_backup:/pgbackup
      - postgresql_backup_logs:/var/log
    networks:
      - database
    secrets:
      - source: testpgbackup_postgres_password
        target: postgres_password
        mode: 0440
        uid: '70' #postgres
        gid: '70' #postgres
    environment:
      POSTGRES_HOST: postgresql
      POSTGRES_PORT: 5432
      POSTGRES_USER: testdbuser
      POSTGRES_PASSWORD_FILE: /run/secrets/postgres_password
      POSTGRES_DB: testdb
      POSTGRES_BACKUP_DIR: /pgbackup
      CRON_SCHEDULE: '* * * * *'