Skip to content
This repository

Generic Queue and Replication for PostgreSQL

Fetching latest commit…


Cannot retrieve the latest commit at this time

Octocat-spinner-32 debian
Octocat-spinner-32 doc
Octocat-spinner-32 python
Octocat-spinner-32 scripts
Octocat-spinner-32 sql
Octocat-spinner-32 tests
Octocat-spinner-32 upgrade
Octocat-spinner-32 AUTHORS
Octocat-spinner-32 COPYRIGHT
Octocat-spinner-32 INSTALL
Octocat-spinner-32 Makefile
Octocat-spinner-32 NEWS
Octocat-spinner-32 README
Octocat-spinner-32 source.cfg
= 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.

== Overview ==

It contains following tools:

=== PgQ ===

This is the queue machanism we use.  Consists of PL/pgsql, 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


- 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.


- PgQ admin tool (pgqadm) usage: doc/pgq-admin.txt
- PgQ SQL API overview: doc/pgq-sql.txt
- PgQ SQL reference:

=== Londiste ===

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


- Tables can be added one-by-one into set.
- Initial COPY for one table does not block event replay for other
- Can compare tables on both sides.


- Londiste script usage: doc/londiste.cmdline.txt
  (also available as `man 1 londiste`)
- Londiste configuration: doc/londiste.config.txt
  (also available as `man 5 londiste`)
- Londiste reference: doc/londiste.ref.txt

=== 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.