#!/usr/bin/env bash # ============================================================================== # ClassNotify P2.5 Automated PostgreSQL Backup with Operational Health Status # Target: Tokyo VPS Local Retained Backups (/var/backups/classnotify) # Format: PostgreSQL Custom Archive (-Fc) # Checksum: SHA-256 integrity hash (.sha256) # Retention: 14 daily backups, 4 weekly snapshots # Health: Writes /var/lib/classnotify/ops/backup-status.json for /api/health/diagnostics # Verification: Automatically executes /usr/local/sbin/classnotify-restore-gate.sh # ============================================================================== set -euo pipefail BACKUP_DIR="/var/backups/classnotify" DAILY_DIR="${BACKUP_DIR}/daily" WEEKLY_DIR="${BACKUP_DIR}/weekly" STATUS_DIR="/var/lib/classnotify/ops" STATUS_FILE="${STATUS_DIR}/backup-status.json" mkdir -p "${DAILY_DIR}" "${WEEKLY_DIR}" "${STATUS_DIR}" chown -R postgres:postgres "${BACKUP_DIR}" TIMESTAMP=$(date +"%Y%m%d_%H%M%S") DAILY_FILE="${DAILY_DIR}/classnotify_${TIMESTAMP}.dump" SHA256_FILE="${DAILY_FILE}.sha256" START_TIME=$(date +%s%3N) echo "[$(date -u +"%Y-%m-%dT%H:%M:%SZ")] Starting ClassNotify PostgreSQL cold backup (custom format -Fc)..." # Dump via postgres superuser sudo -u postgres pg_dump -d classnotify -Fc -f "${DAILY_FILE}" FILESIZE=$(stat -c%s "${DAILY_FILE}" 2>/dev/null || stat -f%z "${DAILY_FILE}" 2>/dev/null || wc -c < "${DAILY_FILE}") if [ "${FILESIZE}" -lt 500 ]; then echo "ERROR: Backup file ${DAILY_FILE} is abnormally small (${FILESIZE} bytes)!" >&2 exit 1 fi chmod 600 "${DAILY_FILE}" # Compute SHA-256 Checksum SHA256_HASH=$(sha256sum "${DAILY_FILE}" | awk '{print $1}') echo "${SHA256_HASH} $(basename "${DAILY_FILE}")" > "${SHA256_FILE}" chmod 644 "${SHA256_FILE}" END_TIME=$(date +%s%3N) DURATION_MS=$((END_TIME - START_TIME)) NOW_UTC=$(date -u +"%Y-%m-%dT%H:%M:%SZ") echo "[${NOW_UTC}] Daily custom backup created: ${DAILY_FILE} (${FILESIZE} bytes, SHA256: ${SHA256_HASH}, Duration: ${DURATION_MS}ms)" # If Sunday (day 7), create weekly snapshot DAY_OF_WEEK=$(date +%u) if [ "${DAY_OF_WEEK}" -eq 7 ]; then WEEKLY_FILE="${WEEKLY_DIR}/classnotify_weekly_${TIMESTAMP}.dump" cp "${DAILY_FILE}" "${WEEKLY_FILE}" cp "${SHA256_FILE}" "${WEEKLY_FILE}.sha256" echo "[${NOW_UTC}] Weekly snapshot created: ${WEEKLY_FILE}" fi # Retention policy: retain last 14 daily backups find "${DAILY_DIR}" -type f \( -name "classnotify_*.dump" -o -name "classnotify_*.dump.sha256" \) -mtime +14 -delete 2>/dev/null || true # Retention policy: retain last 4 weekly backups (28 days) find "${WEEKLY_DIR}" -type f \( -name "classnotify_weekly_*.dump" -o -name "classnotify_weekly_*.dump.sha256" \) -mtime +28 -delete 2>/dev/null || true # Write operational health status file for /api/health/diagnostics TMP_STATUS="${STATUS_FILE}.tmp" cat < "${TMP_STATUS}" { "lastSuccessUtc": "${NOW_UTC}", "backupFile": "${DAILY_FILE}", "sha256": "${SHA256_HASH}", "sizeBytes": ${FILESIZE}, "durationMs": ${DURATION_MS}, "format": "pg_dump_custom_fc", "status": "Healthy" } EOF mv "${TMP_STATUS}" "${STATUS_FILE}" chmod 644 "${STATUS_FILE}" echo "[${NOW_UTC}] ClassNotify PostgreSQL backup completed and health status updated." # Automatically trigger Sandbox Restore Drill verification if [ -x "/usr/local/sbin/classnotify-restore-gate.sh" ]; then echo "[${NOW_UTC}] Triggering automated Sandbox Restore Drill..." /usr/local/sbin/classnotify-restore-gate.sh "${DAILY_FILE}" fi exit 0