Mimeo 0.8.3

Developer: Website: License / Price: Platforms: Databases: Language: Last Updated: Category: Keith Fiske | More scripts github.com Other Free / Open Source License - PostgreSQL License  Windows / Linux / Mac OS / BSD / Solaris PostgreSQL Unknown December 6th, 2012, 20:54 GMT [view history] C: \ Database Tools

Mimeo can be used to move database tables from one PostgreSQL database to another.

Includes support for three replication strategies:
1. Snapshot - entire table copied from one DB to another
2. Incremental - data is moved as new content is detected
3. DML - takes data from one database and permanently moves it to a new location

Requirements:

· PostgreSQL 9.1 or higher
· pg_jobmon 0.3 or higher
· PostgreSQL dblink extension

What's New in This Release: [ read full changelog ]

· Fixed dml refresh not propagating updates and deletes.
· Fixed dml/logdel refresh not updating a row if it has a multi-column primary/unique key and only a subset of the columns of that key are changed.
· Fixed edge case in refresh_dml/logdel where, if the batch limit was hit, the remote queue table might not mark the processed rows properly.
· Changed tests to use pgTAP. Testing suite is now much more extensive and helped find above bugs.