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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
