Postgres backup (WP-BACKUP-PG-01)
Scripts
| Script | Việc |
|---|---|
deploy/backup-postgres.sh |
pg_dump → /var/backups/welife/postgres/*.sql.gz · giữ 14 ngày |
deploy/restore-postgres-drill.sh |
Restore vào DB tạm welife_restore_drill rồi drop (không đụng prod) |
Cron (VPS)
install -d -m 700 /var/backups/welife/postgres
install -m 750 /opt/welife/deploy/backup-postgres.sh /usr/local/sbin/welife-pg-backup
install -m 750 /opt/welife/deploy/restore-postgres-drill.sh /usr/local/sbin/welife-pg-restore-drill
cat >/etc/cron.d/welife-pg-backup <<'EOF'
# WELIFE Postgres daily dump 02:15 UTC
15 2 * * * root /usr/local/sbin/welife-pg-backup >>/var/log/welife-pg-backup.log 2>&1
EOF
chmod 644 /etc/cron.d/welife-pg-backup
Smoke
/usr/local/sbin/welife-pg-backup
/usr/local/sbin/welife-pg-restore-drill
ls -lh /var/backups/welife/postgres/
Env override: WELIFE_ROOT · WELIFE_BACKUP_DIR · WELIFE_BACKUP_KEEP_DAYS · POSTGRES_* (từ /opt/welife/.env).