Top
Enterprise Postgres 17 Installation and Setup Guide for Server

4.7.9 Pgpool-II

4.7.9.1 Setting Up Pgpool-II

  1. As superuser, run the following command:

    $ su -
    Password:******
    # cp -r /opt/fsepv<x>server64/OSS/Pgpool-II/* /opt/fsepv<x>server64
  2. Execute CREATE EXTENSION for the database that will use this feature.
    Use the psql command to connect to the "postgres" database.

    postgres=# CREATE EXTENSION pgpool_recovery;
    CREATE EXTENSION
  3. Set the postgresql.conf file parameters.
    Specify the path to pg_ctl for the pgpool.pg_ctl parameter.

  4. Restart Fujitsu Enterprise Postgres.

Note

The online recovery feature of Pgpool-II cannot be used on instances created in WebAdmin. It can only be used via server commands.

4.7.9.2 Removing Pgpool-II

  1. Execute DROP EXTENSION for the database that will use this feature.
    Use the psql command to connect to the "postgres" database.

    postgres=# DROP EXTENSION pgpool_recovery CASCADE;
    DROP EXTENSION
  2. As superuser, run the following command:

    $ su -
    Password:******
    # rm -rf /opt/fsepv<x>server64/filesCopiedDuringSetup

    Information

    The files copied during setup can be checked below.

    # find /opt/fsepv<x>server64/OSS/Pgpool-II
  3. Set the postgresql.conf file parameters.
    Delete the pg_ctl path for the pgpool.pg_ctl parameter.

  4. Restart Fujitsu Enterprise Postgres.