1.71.5 Checkpoint and Recovery

Safeguarding the content of your database against disasters, both hardware and malicious use, requires carefully planned steps. The first line of defense is to keep the database logs physically separated from the database store itself, e.g. on different disks. The second line of defense is to regularly create a database dump or full checkpoint. This is a consolidated snapshot and should be stored away at a failure independent location, e.g. a vault. Since a dump is a rather expensive operation, the third line of defense is to keep differential lists from the last dump based on the update logs. It forms a basis to rollback to a known correct state.

We are working on this topic

At the moment the best way to make a checkpoint is to make a database dump while the database is under maintenance. Use the monetdb utility to lock the database before dumping its contents.