SkyTools For Mac

SkyTools is a free and open source package of tools provided by the Skype Team to manage clusters of PostgreSQL servers.

Replication engine written in Python. It uses PgQ as transport mechanism. Its main goals are robustness and easy usage. Thus its not as complete and featureful as Slony-I.

Features: · Tables can be added one-by-one into set. · Initial COPY for one table does not block event replay for other tables. · Can compare tables on both sides. · Supports sequences. · Easy installation.   

Generic queue implementation. Based on ideas from Slony-I - snapshot based event batching.

Features: · Generic multi-consumer, multi-producer queue. · There can be several consumers on one queue. · It is guaranteed that each of them sees a event at least once. But it's not guaranteed that it sees it only once. · The goal is to provide a clean API as SQL functions. The frameworks on top of that don't need to understand internal details.

Technical design: · Events are batched using snapshots (like Slony-I). · Consumers are poll-only, they don't need to do any administrative work. · Queue administration is separate process from consumers. · Tolerant of long transactions. · Easy to monitor.