Skip to content
Generic Queue and Replication for PostgreSQL http://pgfoundry.org/projects/skytools/
Python PLpgSQL C Shell Other
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
debian
doc
python
scripts
sql
tests
AUTHORS
COPYRIGHT
Makefile
NEWS
README
config.mak.in
configure.ac
setup.py
source.cfg

README

SkyTools - tools for PostgreSQL
===============================

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.

It contains following tools:

PgQ
---

This is the queue machanism we use.  Consists of PL/pgsql, PL/python
and C code in database, with Python framework on top of it.  It is
based on snapshot based event handling ideas from Slony-I,
written for general usage.

Features:

  * There can be several queues in database.
  * There can be several producers than can insert into any queue.
  * There can be several consumers on one queue and all consumers
    see all events.


Londiste
--------

Replication tool written in Python, using PgQ as event transport.

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.


walmgr
------

This script will setup WAL archiving, does initial backup and
runtime WAL archive and restore.




Something went wrong with that request. Please try again.