Installation from RPM

2.10.1. Installing RPM

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

For RHEL and its derivatives do following once:

    yum install https://www.pgpool.net/yum/rpms/4.1/redhat/rhel-7-x86_64/pgpool-II-release-4.1-2.noarch.rpm
   

Then:

    yum install pgpool-II-pg12
   

pg12 means PostgreSQL 12 . 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-pg12-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-pg12-devel
   

This installs header files which developers are interested in.

On all the PostgreSQL servers you need to install:

    yum install pgpool-II-pg12-extensions
   

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