E-Maj 1.0.1

A PostgreSQL script to creates the objects needed to log and rollback table updates
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.

Main features:

  • 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

last updated on:
January 11th, 2013, 14:03 GMT
price:
FREE!
developed by:
Philippe Beaudoin
homepage:
pgfoundry.org
license type:
BSD License
operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
category:
C: \ Database Tools

FREE!

In a hurry? Add it to your Download Basket!

user rating 2

5.0/5
 

0/5

Rate it!
What's New in This Release:
  • Fixed an abort in rollback processing when a deferrable foreign key links two tables, one not being covered by E-Maj, and the other having events to rollback.
read full changelog

Add your review!

SUBMIT