64 lines
2.1 KiB
Bash
64 lines
2.1 KiB
Bash
|
#!/bin/sh
|
||
|
|
# Nightly Postgres backup loop for Meezi.
|
||
|
|
#
|
||
|
|
# Runs inside a small postgres-image container (has pg_dump/gzip). Every day at
|
||
|
|
# ~02:00 Tehran it dumps the whole database, gzips it, and keeps the last
|
||
|
|
# RETAIN_DAYS files in /backups. Designed to be dead-simple and dependency-free:
|
||
|
|
# no cron daemon, just sleep-until-next-run so it survives container restarts.
|
||
|
|
#
|
||
|
|
# Env:
|
||
|
|
# PGHOST, PGUSER, PGPASSWORD, PGDATABASE — connection (from compose)
|
||
|
|
# RETAIN_DAYS — how many daily dumps to keep (default 14)
|
||
|
|
# BACKUP_HOUR — local hour to run (default 2 = 02:00)
|
||
|
|
set -eu
|
||
|
|
|
||
|
|
RETAIN_DAYS="${RETAIN_DAYS:-14}"
|
||
|
|
BACKUP_HOUR="${BACKUP_HOUR:-2}"
|
||
|
|
OUT_DIR=/backups
|
||
|
|
export TZ="${TZ:-Asia/Tehran}"
|
||
|
|
|
||
|
|
log() { echo "[pg-backup $(date '+%Y-%m-%d %H:%M:%S %Z')] $*"; }
|
||
|
|
|
||
|
|
run_backup() {
|
||
|
|
ts=$(date '+%Y%m%d_%H%M%S')
|
||
|
|
tmp="$OUT_DIR/.meezi_${ts}.sql.gz.partial"
|
||
|
|
final="$OUT_DIR/meezi_${ts}.sql.gz"
|
||
|
|
log "starting dump → $final"
|
||
|
|
# pg_dump streams to gzip; .partial then atomic rename so a crash never
|
||
|
|
# leaves a truncated file that looks like a good backup.
|
||
|
|
if pg_dump --no-owner --no-privileges | gzip -9 > "$tmp"; then
|
||
|
|
mv "$tmp" "$final"
|
||
|
|
size=$(wc -c < "$final" 2>/dev/null || echo '?')
|
||
|
|
log "done ($size bytes)"
|
||
|
|
else
|
||
|
|
rm -f "$tmp"
|
||
|
|
log "ERROR: dump failed"
|
||
|
|
return 1
|
||
|
|
fi
|
||
|
|
# Rotate: delete dumps older than RETAIN_DAYS days.
|
||
|
|
find "$OUT_DIR" -maxdepth 1 -name 'meezi_*.sql.gz' -mtime "+${RETAIN_DAYS}" -print -delete | while read -r f; do
|
||
|
|
log "rotated out $f"
|
||
|
|
done
|
||
|
|
}
|
||
|
|
|
||
|
|
seconds_until_next_run() {
|
||
|
|
now_h=$(date '+%-H'); now_m=$(date '+%-M'); now_s=$(date '+%-S')
|
||
|
|
now=$(( now_h * 3600 + now_m * 60 + now_s ))
|
||
|
|
target=$(( BACKUP_HOUR * 3600 ))
|
||
|
|
if [ "$now" -lt "$target" ]; then
|
||
|
|
echo $(( target - now ))
|
||
|
|
else
|
||
|
|
echo $(( 86400 - now + target ))
|
||
|
|
fi
|
||
|
|
}
|
||
|
|
|
||
|
|
log "backup loop started (retain ${RETAIN_DAYS}d, daily at ${BACKUP_HOUR}:00 ${TZ})"
|
||
|
|
# Take one backup immediately on first boot so we never sit a full day with none.
|
||
|
|
run_backup || true
|
||
|
|
while true; do
|
||
|
|
wait_s=$(seconds_until_next_run)
|
||
|
|
log "next backup in ${wait_s}s"
|
||
|
|
sleep "$wait_s"
|
||
|
|
run_backup || true
|
||
|
|
done
|