Mimeo 0.10.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 February 17th, 2013, 05:53 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 ]

· New refresh_table option for just doing a straight truncate and repull for a regular table. Only adding as a minor feature because other changes do not affect API and it's not recommended as a regular refresh job if possible. Also refresh_table() does not currently log to pg_jobmon, so cannot be monitored and will not set off any alerts if/when this refresh type fails. What this is useful for is having a way to get data from production to a staging/dev database where you still want to be able to edit the destination table. Could do that with Incremental or DML, but this avoids requiring any primary keys, control columns or write access on the source database.
· Removed custom enum type. Made things much more complicated than they needed to be. Enums are REALLY bad in extensions since you can never just add a new value in an update.
· The commands to remove the batch limit defaults & set the default boundaries for incremental replication were missing from the mimeo--0.9.3--0.10.1 bypass update file. If that file was used to update mimeo, the defaults were never changed and limits were still being set for new refresh jobs. Run those here again.

Via: Mimeo 0.10.3