Бэкап базы данных по расписанию — с алертом, если он не пришёл

# crontab -e — каждые 6 часов; полный путь к бинарнику: which dbsend
0 */6 * * * cd /srv/app && /usr/local/bin/dbsend backup ./data.db >> /var/log/dbsend.log 2>&1

# дамп PostgreSQL каждую ночь в 03:15 (пароль — в ~/.pgpass)
15 3 * * * pg_dump --format=plain -U app app > /var/backups/app.sql && /usr/local/bin/dbsend backup /var/backups/app.sql -d 9b17… -e postgresql_dump >> /var/log/dbsend.log 2>&1

# /etc/systemd/system/dbsend-backup.service
[Unit]
Description=dbsend backup

[Service]
Type=oneshot
User=app
WorkingDirectory=/srv/app
ExecStart=/usr/local/bin/dbsend backup ./data.db

# /etc/systemd/system/dbsend-backup.timer
[Unit]
Description=dbsend backup every 6 hours

[Timer]
OnCalendar=*-*-* 00/6:00:00
Persistent=true
RandomizedDelaySec=5m

[Install]
WantedBy=timers.target

# включение и проверка
sudo systemctl daemon-reload
sudo systemctl enable --now dbsend-backup.timer
systemctl list-timers dbsend-backup.timer
journalctl -u dbsend-backup.service -n 20

$action  = New-ScheduledTaskAction -Execute "cmd.exe" -Argument "/c dbsend backup C:\app\data.db" -WorkingDirectory "C:\app"
$trigger = New-ScheduledTaskTrigger -Daily -At 3am
Register-ScheduledTask -TaskName "dbsend-backup" -Action $action -Trigger $trigger

# .github/workflows/db-backup.yml
name: db-backup
on:
  schedule:
    - cron: "15 0 * * *"   # UTC — это 03:15 по Москве
  workflow_dispatch:
jobs:
  backup:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/setup-node@v4
        with:
          node-version: 22
      - run: npm install -g @dbsend/sdk
      - run: pg_dump --format=plain "$DATABASE_URL" > app.sql
        env:
          DATABASE_URL: ${{ secrets.DATABASE_URL }}
      - run: dbsend backup ./app.sql -d ${{ vars.DBSEND_DATABASE_ID }} -e postgresql_dump -l "gha-${{ github.run_number }}"
        env:
          DBSEND_API_KEY: ${{ secrets.DBSEND_API_KEY }}