Point-in-time recovery (PITR) in the context of
computer
A computer is a machine that can be programmed to Execution (computing), carry out sequences of arithmetic or logical operations (computation) automatically. Modern digital electronic computers can perform generic sets of operations known as C ...
s involves systems, often
databases, 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 (for instance, before data corruption occurred).
Time Machine
Time travel is the concept of movement between certain points in time, analogous to movement between different points in space by an object or a person, typically with the use of a hypothetical device known as a time machine. Time travel is a w ...
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
backup
In information technology, a backup, or data backup is a copy of computer data taken and stored elsewhere so that it may be used to restore the original after a data loss event. The verb form, referring to the process of doing so, is "back up", w ...
s to the state that it had at any time since.
See also
*
Continuous data protection Continuous data protection (CDP), also called continuous backup or real-time backup, refers to backup of computer data by automatically saving a copy of every change made to that data, essentially capturing every version of the data that the user s ...
References
External links
PostgreSQL Continuous Archiving and Point-in-Time Recovery (PITR)
Data management
{{Compu-stub