3.10. Installation from RPM

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

3.10.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.10.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.10.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.