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

    dnf install https://www.pgpool.net/yum/rpms/4.3/redhat/rhel-8-x86_64/pgpool-II-release-4.3-1.noarch.rpm
   

Then:

    dnf install pgpool-II-pg13
   

pg13 means PostgreSQL 13. 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:

    dnf install pgpool-II-pg13-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.

    dnf install pgpool-II-pg13-devel
   

This installs header files which developers are interested in.

On all the PostgreSQL servers you need to install:

    dnf install pgpool-II-pg13-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.