Point-in-time recovery
Appearance
Point-in-time recovery (PITR) in the context of computers is a system whereby a set of data or a particular setting can be restored or recovered from a time in the past. An example of this is Windows XP's feature of being able to restore operating system settings from a past date (before data corruption occurred, for example). Also, Time Machine for Mac OS X is an example of Point-in-time recovery.
A database with the PITR feature can be restored from backups to the state that it had at any time since PITR logging was started for that database.
External links
- PostgreSQL Continuous Archiving and Point-In-Time Recovery (PITR) blog/article
- MySQL 5.5 Point in Time Recovery