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

Get PostgreSQL High Performance Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.