Replication using Bucardo

In this recipe, we are going to show the replication between two databases using Bucardo, which is another replication tool that replicates data among multiple master nodes. As with the other two tools, this tool is also dependent on triggers at the source tables.

Getting ready

This exercise is carried out in a Red Hat Linux machine.

Install the EPEL package for your Red Hat platform from the following URL:  https://fedoraproject.org/wiki/EPEL.

Then install these RPMs with the following yum command:

yum install perl-DBI perl-DBD-Pg perl-DBIx-Safe 

If it is not already installed, download the Postgresql repository from the following web link:  http://yum.pgrpms.org/repopackages.php

After this, install the following package. This is required because Bucardo is written in Perl:

yum install postgresql96-plperl

To install Bucardo, download it from the following web link: http://bucardo.org/wiki/Bucardo

Extract the tarball and go to the newly downloaded location and...