Talk:Point-in-time recovery

From Wikipedia, the free encyclopedia

Created the page, saw it linked from PostgreSQL and felt some clarification might need to be made for some people who aren't familiar with this. grrowl 04:12, 31 March 2006 (UTC)

Point-in-time (PIT) rollback works like an undo would in a document except here file and registry changes are undoable.

While initializing a PIT the disk of interest makes a copy of the tree tables.

Then as changes are made throughout the disk space they are recorded in that one particular PIT file space.

Changes made to each disk block are "Stacked". To rollback to some previous time the changes are unstacked and undone.


The advantage here should be only changes are stored this enables the host to continue in real time.

This is a lighter task than overwriting a whole file for each change.


This PIT / Undo process is useful for across the network backups and replications.

Jimchris 23:53, 2 October 2006 (UTC) Jimchris