These aforementioned objects are recorded into a specific schema, named "emaj" from which the rollback can be called.
It mainly contains few technical tables, a set of functions, and one "log table" per processed application table.
Documentation is included in the download pacakge.
Here are some key features of "E-Maj":
· Set inter-batch savepoints on group of tables,
· Easily "restore" a group of tables at a stable state, without being obliged to stop the cluster,
· Handle several savepoints during batch windows, each of them been usable at any time as "restore point",
· Consequently suppress a mirror of the databases (a part of the freed disk space being dedicated to additional space needed for log tables),
· Consequently decrease the number of clusters by grouping several databases into a single cluster,
· Allow use of PostgreSQL advanced features like log-shipping and PITR
Requirements:
· PostgreSQL
What's New in This Release: [ read full changelog ]
· The 0.9 version includes some enhancements like a new function to estimate the duration of rollback operations.
· A rich documentation in PDF format is now supplied.