Point-in-time recovery (PITR) in the context of
computer
A computer is a machine that can be Computer programming, programmed to automatically Execution (computing), carry out sequences of arithmetic or logical operations (''computation''). Modern digital electronic computers can perform generic set ...
s involves systems, often
databases
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and ana ...
, 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
Windows is a Product lining, product line of Proprietary software, proprietary graphical user interface, graphical operating systems developed and marketed by Microsoft. It is grouped into families and subfamilies that cater to particular sec ...
's capability to restore operating-system settings from a past date (for instance, before data corruption occurred).
Time Machine for macOS provides another example of point-in-time recovery.
Once PITR logging starts for a PITR-capable
database
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...
, a
database administrator
A database administrator (DBA) manages computer databases. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data re ...
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 "wikt:back ...
s to the state that it had at any time since.
See also
*
Continuous data protection
*
Data version control
References
External links
PostgreSQL Continuous Archiving and Point-in-Time Recovery (PITR)
Data management
{{Compu-stub