Replication using Londiste

In this recipe, we are going to show how to replicate data using Londiste, which is based on a queue that is populated by a set of producers, and consumed by a set of consumers. It is also similar to Slony replication, which is needed to create a set of event triggers on source tables.

Getting ready

For this setup, we are using the same host CentOS Linux machine to replicate data between two databases. This can also be set up using two separate Linux machines running on Vmware or VirtualBox or any other virtualization software. It is assumed that Postgresql version 9.6 is installed. We have used CentOs version 6 as the Linux operating system for this exercise. To set up Londiste replication on the Linux machine, follow these steps:

1. Go to the following link and download the latest version of skytools 3.2, that is, tarball skytools-3.2.tar.gz: http://pgfoundry.org/projects/skytools/

2. Extract the tar ball as follows:

           tar -xvf skytools-3.2.tar.gz 
   
   

3. Go to the...