Installing pgpool-II

In this recipe, we are going to install pgpool.

Getting Ready

Installing pgpool from source requires GCC 2.9 or higher and GNU Make. Since pgpool links with the libpq library, the libpq library and its development headers must be installed prior to installing pgpool. Also the OpenSSL library and its development headers must be present in order to enable OpenSSL support in pgpool.

How to do it...

To install pgpool in a Debian or Ubuntu-based distribution we can execute the following command:

apt-get install pgpool2 

On Red Hat, Fedora, CentOS, or any other RHEL-based Linux distributions, use the following command:

yum install pgpool* 

If you are building from source, then follow these steps:

1. Download the latest tarball of pgpool from the following website: http://www.pgpool.net/mediawiki/index.php/Downloads.
2. The next step is to extract the pgpool tarball and enter the source directory:

           tar -xzf pgpool-II-3.4.0.tar.gz 
           cd pgpool-II-3.4.0 
   
   

3. The next...