To install Slony, first download the most recent tarball from http://slony.info. As always, we will perform a source installation so that we are able to perform replication.

For the purpose of this chapter, we have used the version of Slony available at http://main.slony.info/downloads/2.2/source/slony1-2.2.4.tar.bz2.

Once we have downloaded the package, we can extract it by running the following command:

tar xvfj slony1-2.2.4.tar.bz2

The tarball will inflate, and we can move forward to compile the code. To build the code, we must tell Slony where to look for pg_config. The purpose of pg_config is to provide the add-on module with all of the information about the build process of PostgreSQL itself. In this way, we can ensure that PostgreSQL and Slony are compiled in the same way. The pg_config file is quite common and is widely used by many tools built on PostgreSQL. In our demo setup, PostgreSQL resides in /usr/local/pgsql, so we can safely assume that PostgreSQL will reside...