عرض عملي: الاستعادة إلى ما قبل DELETE خاطئ بخمس دقائق

خطوة بخطوة

1. Enable WAL archiving and take a base backup; write down the time.
2. Run workload, note a safe timestamp, then run DELETE FROM orders without a WHERE clause.
3. Stop the server and move the damaged data directory aside; restore the base backup.
4. Set recovery_target_time to five minutes before the delete, create recovery.signal, and start.
5. Planned mistake: target a time after the delete; the rows are gone again. Fix: choose an earlier target and repeat.
6. Verify row counts, promote, and record the elapsed recovery time.

Prepares MID-018-LAB1.

اختبر فهمك