Point-in-time recovery
It is proposed that this article be deleted because of the following concern:
If you can address this concern by improving, copyediting, sourcing, renaming, or merging the page, please edit this page and do so. You may remove this message if you improve the article or otherwise object to deletion for any reason. Although not required, you are encouraged to explain why you object to the deletion, either in your edit summary or on the talk page. If this template is removed, do not replace it. This message has remained in place for seven days, so the article may be deleted without further notice. Find sources: "Point-in-time recovery" – news · newspapers · books · scholar · JSTOR Nominator: Please consider notifying the author/project: {{subst:proposed deletion notify|Point-in-time recovery|concern=Wikipedia is not a glossary of computer terminology. Article has been unsourced since 2009, and I can find no good references. Furthermore, the accuracy of this article has been challenged on the talk page}} ~~~~ Timestamp: 20140818071517 07:15, 18 August 2014 (UTC) Administrators: delete |
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), or PostgreSQL's feature of being able to view a database table and its data as it was at a particular date in the past. Also, Time Machine for Mac OS X is an example of Point-in-time recovery.
A database with the PITR feature can be restored or recovered to the state that it had at any time since PITR logging was started for that database.
The PostgreSQL database implements Continuous Archiving and Point-In-Time Recovery. In PostgreSQL, Write-ahead logging (WAL) must be enabled for a particular database, in order for PITR to be used on that database; any time after WAL is enabled for a database, that database may be restored to any later time.
External links
- PostgreSQL Continuous Archiving and Point-In-Time Recovery (PITR) blog/article
- MySQL 5.5 Point in Time Recovery