Point-in-time recovery
"PITR" redirects here. For other uses, see Pitr.
Point-in-time recovery (PITR) in the context of computers involves systems whereby an administrator can restore or recover a set of data or a particular setting from a time in the past. Note for example Windows XP's capability to restore operating-system settings from a past date (before data corruption occurred, for example). Time Machine for Mac OS X provides another example of point-in-time recovery.
Once PITR logging starts for a PITR-capable database, a database administrator can restore that database from backups to the state that it had at any time since.
External links
- PostgreSQL Continuous Archiving and Point-In-Time Recovery (PITR) blog/article
- MySQL 5.5 Point in Time Recovery
This article is issued from Wikipedia - version of the 8/5/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.