Jump to content

Point-in-time recovery

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Zenaan (talk | contribs) at 12:55, 16 September 2010 (Copied over the PITR stub to here - PITR now needs a cleanup/ redirect/ disambiguation page.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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.

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.


Stub icon

This computing article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Point-in-time_recovery&oldid=385161254"