Point-in-time recovery
(Redirected from PITR)
Point-in-time recovery (PITR) in the context of computers 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.[1][2][3] Note for example Windows'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, a database administrator can restore that database from backups to the state that it had at any time since.[1]
See also
[edit | edit source]References
[edit | edit source]- ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
External links
[edit | edit source]- PostgreSQL Continuous Archiving and Point-in-Time Recovery (PITR)
- MySQL 8.0 Point-in-Time Recovery Using the Binary Log