O'Reilly logo

PostgreSQL Cookbook by Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Replication using Bucardo

In this recipe, we are going to show you the replication between two databases using Bucardo.

Getting ready

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required