Installation from RPM

This chapter describes the installation of Pgpool-II from PRM. If you are going to install from the source code, please check Section 3.1 .

3.9.1. Installing RPM

Pgpool-II official RPMs can be obtained from http://www.pgpool.net/yum .

For RHEL and its derivatives do following once:

yum install http://www.pgpool.net/yum/rpms/3.6/redhat/rhel-7-x86_64/pgpool-II-release-3.6-1.noarch.rpm
     

Then:

yum install pgpool-II-pg96
     

pg96 means PostgreSQL 9.5 . Pgpool-II needs PostgreSQL 's library and extensions directory. Since the directory paths are different in the particular PostgreSQL versions, You must choose appropriate RPM for your PostgreSQL rpm installation. We also assume you are using PostgreSQL community rpms . Optionally you can install:

yum install pgpool-II-pg96-debuginfo
     

which makes it easier to retrieve debugging symbols from the core or the backtrace. We recommend to install it. There is an optional package for developers.

yum install pgpool-II-pg96-devel
     

This installs header files which developers are interested in

On all the PostgreSQL servers you need to install:

yum install pgpool-II-pg96-extensions
     

3.9.2. Configuration with RPM

All the Pgpool-II configuration files live in /etc/pgpool-II . Please refer to Section 3.8 to see how to set up configuration files.

3.9.3. Starting/stopping Pgpool-II

On RHEL7/CentOS 7, do this once.

systemctl enable pgpool.service
       

After this, restart the whole system or:

systemctl start pgpool.service 
       

Please note that PostgreSQL servers must have been started before this. To stop Pgpool-II :

systemctl stop pgpool.service 
       

After this, you can stop PostgreSQL servers.

On RHEL6/CentOS 6, do this once.

chkconfig pgpool on
       

After this, restart the whole system or:

service start pgpool
       

Please note that PostgreSQL servers must have been started before this. To stop Pgpool-II :

service stop pgpool
       

After this, you can stop PostgreSQL servers.