Thread: data diffs with pg51g

data diffs with pg51g

From
Michael Nacos
Date:
pg51g is a data diff toolkit for PostgreSQL. It is meant to be
pronounced 'pee-gee-sig' -- which is what you get if you unfocus
enough while looking at the name :-) I know, it's a terrible name.

It is also an accurate name, as it generates and maintains md5-based
signature tables for your relations in a PostgreSQL database. These
sig tables may be used in two ways:

* for comparing data across databases
* for comparing the current state of a database with a saved snapshot
of itself (self-diff)

This software has been based on Fabien Coelho's report on Remote
Comparison of Database Tables, which may be found here:
http://cri.ensmp.fr/classement/doc/A-375.pdf This software, however,
represents a brand new implementation in C and PL/pgSQL, with
modifications.

http://pgdba.net/pg51g/

comments, suggestions, contributions welcome!

regards, Michael Nacos