#!/usr/bin/env bash # ============================================================================== # ClassNotify Automated PostgreSQL Database Backup Script # Target: Oracle VPS Local Retained Backups (/var/backups/classnotify) # Retention: 7 daily backups, 4 weekly snapshots # ============================================================================== set -euo pipefail BACKUP_DIR="/var/backups/classnotify" DAILY_DIR="${BACKUP_DIR}/daily" WEEKLY_DIR="${BACKUP_DIR}/weekly" mkdir -p "${DAILY_DIR}" "${WEEKLY_DIR}" TIMESTAMP=$(date +"%Y%m%d_%H%M%S") DAILY_FILE="${DAILY_DIR}/classnotify_${TIMESTAMP}.sql.gz" echo "[$(date)] Starting ClassNotify PostgreSQL backup..." # Extract password from /etc/classnotify/classnotify.env if available, or dump via postgres user if [ -f "/etc/classnotify/classnotify.env" ]; then ENV_STR=$(grep "ConnectionStrings__DefaultConnection=" /etc/classnotify/classnotify.env | cut -d'=' -f2-) DB_PASS=$(echo "${ENV_STR}" | sed -n 's/.*Password=\([^;]*\).*/\1/p') PGPASSWORD="${DB_PASS}" pg_dump -h 127.0.0.1 -U classnotify -d classnotify | gzip -9 > "${DAILY_FILE}" else sudo -u postgres pg_dump classnotify | gzip -9 > "${DAILY_FILE}" fi FILESIZE=$(stat -c%s "${DAILY_FILE}") if [ "${FILESIZE}" -lt 100 ]; then echo "ERROR: Backup file ${DAILY_FILE} is abnormally small (${FILESIZE} bytes)!" >&2 exit 1 fi echo "[$(date)] Daily backup created: ${DAILY_FILE} (${FILESIZE} bytes)" # 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}.sql.gz" cp "${DAILY_FILE}" "${WEEKLY_FILE}" echo "[$(date)] Weekly snapshot created: ${WEEKLY_FILE}" fi # Retention policy: retain last 7 daily backups find "${DAILY_DIR}" -type f -name "classnotify_*.sql.gz" -mtime +7 -exec rm -f {} + # Retention policy: retain last 4 weekly backups (28 days) find "${WEEKLY_DIR}" -type f -name "classnotify_weekly_*.sql.gz" -mtime +28 -exec rm -f {} + echo "[$(date)] ClassNotify PostgreSQL backup completed successfully." exit 0