- Implemented ops/audit.sh for sub-second system state snapshotting - Automated CHANGELOG.md updates with daily metrics (LXC, alerts, disk, git) - Verified auto-commit and auto-push to Gitea main branch - Scheduled daily execution via cron at 09:00 - Added supporting scripts to version control (audit.sh, backup.sh)
33 lines
1.4 KiB
Bash
Executable File
33 lines
1.4 KiB
Bash
Executable File
#!/bin/bash
|
|
set -e
|
|
|
|
BACKUP_DIR="/root/buryan-infra/ops/backups"
|
|
DATE=$(date +%Y-%m-%d_%H-%M)
|
|
|
|
echo "🚀 Начало резервного копирования Buryan Hub..."
|
|
mkdir -p "$BACKUP_DIR"
|
|
cd /root/buryan-infra
|
|
|
|
# 1. Экспорт PostgreSQL (buryan_monitoring)
|
|
echo "📦 1. Экспорт PostgreSQL (buryan_monitoring)..."
|
|
pct exec 151 -- sudo -u postgres pg_dump -d buryan_monitoring > "$BACKUP_DIR/buryan_monitoring_$DATE.sql"
|
|
echo " ✅ SQL дамп создан: $(ls -lh "$BACKUP_DIR/buryan_monitoring_$DATE.sql" | awk '{print $5}')"
|
|
|
|
# 2. Экспорт всех воркфлоу n8n через CLI (вывод напрямую в файл на хосте)
|
|
echo "📦 2. Экспорт воркфлоу n8n..."
|
|
pct exec 108 -- docker exec n8n n8n export:workflow --all > "$BACKUP_DIR/n8n_workflows_$DATE.json"
|
|
echo " ✅ n8n воркфлоу экспортированы: $(ls -lh "$BACKUP_DIR/n8n_workflows_$DATE.json" | awk '{print $5}')"
|
|
|
|
# 3. Коммит и пуш в Gitea
|
|
echo "📦 3. Коммит изменений в Gitea..."
|
|
git add ops/backups/
|
|
git commit -m "chore(backup): automated daily backup $DATE
|
|
|
|
- pg_dump: buryan_monitoring
|
|
- n8n: all workflows exported via CLI" || echo " ⚠️ Нет изменений для коммита"
|
|
|
|
git push origin main || echo " ⚠️ Git push не выполнен"
|
|
|
|
echo ""
|
|
echo "✅ Резервное копирование успешно завершено!"
|