In this recipe, we are going to show you the replication between two databases using Bucardo.
This exercise is carried out on a Red Hat Linux machine.
Install the EPEL
package for your Red Hat platform from 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 http://yum.pgrpms.org/repopackages.php.
After this, install the following package; this is required because Bucardo is written in Perl:
yum install postgresql93-plperl
To install Bucardo, download the latest version of Bucardo, which is Bucardo Version 5.2.0, from http://bucardo.org/wiki/Bucardo.
Extract from the tarball file, go to the newly downloaded location, and compile and build the software:
tar xvfz Bucardo-5.2.0.tar.gz cd Bucardo-5.2.0 perl Makefile.PL make make install