Restore only changed pages using bitmaps
PeterZ:
Lets say I have taken full backup yesterday with LSN=1000 and have
changes created today there is LSN=2000 and I want to roll back to
the state of yesterday for whatever reason. Instead of copying
full data from that backup I can just copy changed pages to perform
rollback. If we have full backup plus couple of incremental
backups it becomes more complicated of course.
Anyway I do not think we need to rush something like this. I
mainly though this is an interesting conceptual idea though it is
not priority to do it in practice.
Laurynas: this would only work if the server data dir is knowingly non-corrupted. Also, not sure what to do about the new data pages at the end of tablespaces. Probably the tablespaces would remain extended to their size at LSN 2000, and then not sure if the extra data page presence would cause any problems or not.
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Discussion
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by