Home > Uncategorized > Database: Postgresql Asynchronous synchronization with Bucardo on CentOS6

Database: Postgresql Asynchronous synchronization with Bucardo on CentOS6

In order to provide synchronization between two WAN sites (high latency), you would want an asynchronous replication solution.

For our instance, Bucardo allows multi-master, which is what we wanted.

This is (hopefully) the first post related to a full configuration of bucardo. For some more info, refer to Bucardo multi-master for PostgreSQL.


Install postgresql from the postgresql repo:

1) Open each .repo in /etc/yum.repos.d and add the following below each [section]
exclude=postgresql*
2) Add the repo you wish from http://yum.pgrpms.org/repopackages.php

wget http://yum.pgrpms.org/8.4/redhat/rhel-6-i386/pgdg-centos-8.4-3.noarch.rpm
rpm -ivh pgdg-centos-8.4-3.noarch.rpm

Which will install /etc/yum.repos.d/pgdg-84-centos.repo

3) Go ahead and install the postgresql you need:

yum -y install postgresql84 postgresql84-libs postgresql84-devel postgresql84-server

Install bucardo and it’s dependencies:

1) The perl-DBIx-Safe package is not available in the CentOS-base repo, but is available in the Fedora repo:

echo [fedora_repo] >> /etc/yum.repos.d/fedora_repo.repo #allow yum access to the fedora repo
echo name=fedora_repo >> /etc/yum.repos.d/fedora_repo.repo
echo baseurl=http://download1.fedora.redhat.com/pub/epel/\$releasever/\$basearch/ >> /etc/yum.repos.d/fedora_repo.repo
echo enabled=1 >> /etc/yum.repos.d/fedora_repo.repo
echo skip_if_unavailable=1 >> /etc/yum.repos.d/fedora_repo.repo
echo gpgcheck=0 >> /etc/yum.repos.d/fedora_repo.repo

2) Go ahead with the installation:

yum -y install perl-DBI perl-DBD-Pg perl-DBIx-Safe perl-version bucardo

3) Continue with “Create the Bucardo database”: http://bucardo.org/wiki/Bucardo/Installation

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: