Databases · Middle · Question 61 of 75
What is point-in-time recovery (PITR)?
- ✓Correct answer: Restoring a base backup and replaying WAL up to a chosen moment, e.g. just before a bad
DELETE - 2Restoring only the latest daily backup
- 3Undoing the last query with Ctrl+Z
Explanation
It requires continuous WAL archiving. Managed services offer it out of the box with a retention window.