postgresql-cron.json

{
  "id": "pgdump",
  "run": {
    "cpus": 0.5,
    "mem": 512,
    "disk": 0,
    "cmd": "pg_dump --dbname=$PGDB --host=$PGHOST --port=$PGPORT --username=$PGUSER > $BACKUP_FOLDER/$PGHOST-$PGDB-`date +\\%Y-\\%m-\\%d-\\%H-\\%M-\\%S`.sql && gzip $BACKUP_FOLDER/*",
    "docker": {
      "image": "postgres:9.6"
    },
    "env": {
      "BACKUP_FOLDER": "/var/lib/pg_backup",
      "PGPASSWORD": "password",
      "PGUSER": "admin",
      "PGHOST": "postgresql.marathon.l4lb.thisdcos.directory",
      "PGPORT": "5432",
      "PGDB": "defaultdb"
    },
    "volumes": [
      {
        "containerPath": "/var/lib/pg_backup",
        "hostPath": "/var/lib/pg_backup",
        "mode": "RW"
      }
    ]
  },
    "schedules": [
    {
      "id": "default",
      "enabled": true,
      "cron": "0 3 * * *",
      "concurrencyPolicy": "ALLOW"
    }
  ]
}