Skip to content
master
Go to file
Code

Latest commit

…d tables group (missing table, sequence, trigger,...). Previously, we used the emaj_alter_group() function to remove a table or sequence or just repair it. We now use either the remove/assign functions or export and reimport the groups configuration. In passing, fix an error message in _verify_all_groups().
b5f0343

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
sql
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

E-Maj

E-Maj: logs and rollbacks table updates

Version:

License

This software is distributed under the GNU General Public License.

Objectives

The main goals of E-Maj are:

  • log updates performed on one or several sets of tables.
  • cancel these updates if needed, and reset a tables set to a predefined stable state.

In development environments, it brings a good help in testing application, providing an easy way to rollback all updates generated by programs execution, and replay these processings as many times as needed.

In production environments, it brings a good solution to:

  • keep an history of updates performed on tables to examine them in case of problem
  • set inter-batch savepoints on groups of tables,
  • easily "restore" this 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".

It brings a good alternative to the management of several database disk images.

In both environments, being able to examine the history of updates performed on tables can be very helpful in debugging work or for any other purposes.

Distribution

E-Maj is available via the PGXN platform (https://pgxn.org/dist/e-maj/). It is also available on github (https://github.com/dalibo/emaj).

Documentation

A detailed documentation can be found here, in English and in French.

How to install and use E-Maj

E-Maj can be installed using the usual method for postgres extensions (ie. CREATE EXTENSION emaj CASCADE;).

The documentation contains all the detailled information needed to install and use E-Maj.

Emaj_web GUI

Emaj_web is a web GUI tool that brings a user friendly E-Maj administration. It is written in PHP.

The Emaj_web client is available on github.

Its installation and its usage are also described in the documentation.

Contributing

Any contribution on the project is welcome. A part of the documentation deals with how to contribute.

Support

For additional support or bug report, please create an issue on the github repository or contact Philippe BEAUDOIN (phb emaj free fr).

Any feedback is welcome, even to just notice you use and appreciate E-Maj ;-)

About

E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities

Resources

License

Languages

You can’t perform that action at this time.