Contents

pgMemento provides an API to check out previous table or database states from the log tables into a separate database schema. So far, only the data is restored. It's not a real historic replica with views, constraints, indexes, sequences, domains, UDTs, UDFs, FDWs, rules, policies what so ever. At least, primary keys, foreign keys and indexes can be defined, but only on behalf of the current state. I thought about adding dedicated log tables for these three classes but it would require me to write new triggers and new restore and revert functions. This would take up much time where the real benefit might not be so great. As long as users are not requesting this feature it won't get implemented.