Skype offers database management tools including WAL shipping, queueing, and replication. These features allow for efficient database management and replication across multiple servers.
If you're looking for a free and open source package of tools to manage clusters of PostgreSQL servers, consider SkyTools. This tool is provided by the Skype Team and comes with two main components: Londiste and PgQ.
Londiste is a replication engine that's written in Python and uses PgQ as a transport mechanism. Its primary goals are robustness and easy usage, and while it may not be as complete and featureful as Slony-I, it still has plenty of features worth exploring: tables can be added one-by-one into a set, initial COPY for one table doesn't block event replay for other tables, tables can be compared on both sides, and it supports sequences. Plus, it's easy to install.
PgQ is a generic queue implementation that's based on ideas from Slony-I, specifically snapshot-based event batching. It's a generic multi-consumer, multi-producer queue, meaning that there can be several consumers on one queue, and each of them sees an event at least once (though it's not guaranteed that they'll only see it once). With a clean API as SQL functions, the frameworks on top of that don't need to understand internal details. Additionally, technical design features include batched events using snapshots, poll-only consumers that don't need to do administrative work, separate queue administration, tolerance of long transactions, and easy monitoring.
Overall, SkyTools is a great option for managing PostgreSQL servers with its robust and easy-to-use tools.
Londiste is a replication engine that's written in Python and uses PgQ as a transport mechanism. Its primary goals are robustness and easy usage, and while it may not be as complete and featureful as Slony-I, it still has plenty of features worth exploring: tables can be added one-by-one into a set, initial COPY for one table doesn't block event replay for other tables, tables can be compared on both sides, and it supports sequences. Plus, it's easy to install.
PgQ is a generic queue implementation that's based on ideas from Slony-I, specifically snapshot-based event batching. It's a generic multi-consumer, multi-producer queue, meaning that there can be several consumers on one queue, and each of them sees an event at least once (though it's not guaranteed that they'll only see it once). With a clean API as SQL functions, the frameworks on top of that don't need to understand internal details. Additionally, technical design features include batched events using snapshots, poll-only consumers that don't need to do administrative work, separate queue administration, tolerance of long transactions, and easy monitoring.
Overall, SkyTools is a great option for managing PostgreSQL servers with its robust and easy-to-use tools.
What's New
Version 2.1.10: N/A