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 2.1 .

2.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/4.0/redhat/rhel-7-x86_64/pgpool-II-release-4.0-1.noarch.rpm
   

Then:

    yum install pgpool-II-pg11
   

pg11 means PostgreSQL 11 . 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-pg11-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-pg11-devel
   

This installs header files which developers are interested in

On all the PostgreSQL servers you need to install:

    yum install pgpool-II-pg11-extensions
   

2.9.2. Configuration with RPM

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

2.9.3. Starting/stopping Pgpool-II

On RHEL7/CentOS 7, do this once. Do this once, if set the automatic startup of Pgpool-II .

    systemctl enable pgpool.service
   

After this, restart the whole system or do this. Please note that PostgreSQL servers must have been started before this.

    systemctl start pgpool.service 
   

To stop Pgpool-II , do this once. Pgpool-II must need to stop, before PostgreSQL is stopped.

    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.