The package includes database management tools like WAL shipping, queuing, replication.
This is a package of tools in use in Skype for replication and failover.
Also it includes a generic queuing mechanism PgQ and utility library for Python scripts.
The tools are named walmgr, PgQ and Londiste, respectively.
walmgr will setup WAL archiving, does initial backup and runtime WAL archive and restore.
PgQ is a queue machanism. It consists of PL/pgsql, and C code in the database part, with the Python framework on top of it. It is based on snapshot-based events, handling ideas from Slony-I, written for general usage.
Londiste is a replication tool written in Python, using PgQ as event transport.
Here are some key features of "SkyTools":
· A database can have many queues.
· Producers can insert into any queue.
· There can be several consumers for any given queue and all consumers see all events.
What's New in This Release: [ read full changelog ]
· Support for Postgres 9.0.
· walmgr improvements.
· Rest are various fixes.
Find us on Google+
