PGQ-Londiste Replication =================== We all know that the Skytools are popular PostgreSQL Replication tools which have been developed in C/Python and PL/PGSQL. Londiste is the replication which has been implemented on top of PGQ tool which is a snapshot based queuing mechanism. Londiste replication is a Consumer of PGQ which takes the all modifications from PGQ. How to setup PGQ and Londiste Replication --------------------------------------------------------- PGQ ------ PGQ is a queue mechanism which gathers all the transactions/modifications from the provider and keep them ready to consumers{Londiste Replication Demon}. Step 1 ---------- Download the Skytool from the below link. http://pgfoundry.org/frs/download.php/3232/skytools-2.1.13.tar.gz tar -zxvf skytools-2.1.13.tar.gz Step 2 --------- Configure make and make install. [root@localhost skytools-2.1.13]# ./configure --prefix=/opt/PostgreSQL/9.2/Sky --with-pgconfig=/opt/PostgreSQL/9.2/bin/pg...