Visit NES for PostgreSQL Home Page

NES for pgpool-II

Install and configuration guide for NES for pgpool-II, the connection pooler and load balancer for NES for PostgreSQL 14.

NES for pgpool-II is a build of pgpool-II for use with NES for PostgreSQL 14. It sits between PostgreSQL clients and servers and provides connection pooling, load balancing, and high availability.

It is available in the same standard and minimal builds as NES for PostgreSQL 14.

Current versions

Platformpgpool-II version
Most supported platforms4.5.12
RHEL 7, Oracle Linux 74.4.17

pgpool-II ships at 4.5.12 on every supported Unix platform. RHEL 7 and Oracle Linux 7 are pinned to 4.4.17, because upstream pgpool-II 4.5 dropped Enterprise Linux 7 support. pgpool-II is not supported on Windows, which upstream does not support.

Supported platforms

PlatformArchitecture
RHEL / UBI 7, 8, 9, 10x86_64
Oracle Linux 7, 8, 9, 10x86_64
SLES 12 SP5, 15 SP3x86_64
AIX 7.2 TL5ppc64
Solaris 11.4x86_64, SPARC64

Access

NES for pgpool-II is distributed through the NES registry at registry.nes.herodevs.com and requires a HeroDevs access token. If you do not have an access token, contact support@herodevs.com. For more information see Access Tokens.

Installation

pgpool-II ships as a binary tarball alongside the matching NES for PostgreSQL 14 build for your platform.

Asset filenames

Standard build filenames follow the pattern pgpool-II-pg14-<version>-nes-<platform>.tar.gz. Minimal build filenames follow the pattern pgpool-II-pg14-<version>-nes-minimal-<platform>.tar.gz. RHEL 7 and Oracle Linux 7 use version 4.4.17; all other platforms use 4.5.12. Each tarball ships with a matching .sha256 sidecar at the same registry path.

Standard build (4.5.12)

PlatformFilename
RHEL / UBI 8pgpool-II-pg14-4.5.12-nes-rhel8.tar.gz
RHEL / UBI 9pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz
RHEL / UBI 10pgpool-II-pg14-4.5.12-nes-rhel10.tar.gz
Oracle Linux 8pgpool-II-pg14-4.5.12-nes-oraclelinux8.tar.gz
Oracle Linux 9pgpool-II-pg14-4.5.12-nes-oraclelinux9.tar.gz
Oracle Linux 10pgpool-II-pg14-4.5.12-nes-oraclelinux10.tar.gz
SLES 12 SP5pgpool-II-pg14-4.5.12-nes-sles-12sp5.tar.gz
SLES 15 SP3pgpool-II-pg14-4.5.12-nes-sles-15sp3.tar.gz
AIX 7.2 TL5pgpool-II-pg14-4.5.12-nes-aix-7.2-tl5-ppc64.tar.gz
Solaris 11.4 x86_64pgpool-II-pg14-4.5.12-nes-solaris-11.4-x86_64.tar.gz
Solaris 11.4 SPARC64pgpool-II-pg14-4.5.12-nes-solaris-11.4-sparc64.tar.gz
RHEL / UBI 7pgpool-II-pg14-4.4.17-nes-rhel7.tar.gz
Oracle Linux 7pgpool-II-pg14-4.4.17-nes-oraclelinux7.tar.gz

Minimal build (4.5.12)

PlatformFilename
RHEL / UBI 8pgpool-II-pg14-4.5.12-nes-minimal-rhel8.tar.gz
RHEL / UBI 9pgpool-II-pg14-4.5.12-nes-minimal-rhel9.tar.gz
RHEL / UBI 10pgpool-II-pg14-4.5.12-nes-minimal-rhel10.tar.gz
Oracle Linux 8pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux8.tar.gz
Oracle Linux 9pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux9.tar.gz
Oracle Linux 10pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux10.tar.gz
SLES 12 SP5pgpool-II-pg14-4.5.12-nes-minimal-sles-12sp5.tar.gz
SLES 15 SP3pgpool-II-pg14-4.5.12-nes-minimal-sles-15sp3.tar.gz
AIX 7.2 TL5pgpool-II-pg14-4.5.12-nes-minimal-aix-7.2-tl5-ppc64.tar.gz
Solaris 11.4 x86_64pgpool-II-pg14-4.5.12-nes-minimal-solaris-11.4-x86_64.tar.gz
Solaris 11.4 SPARC64pgpool-II-pg14-4.5.12-nes-minimal-solaris-11.4-sparc64.tar.gz
RHEL / UBI 7pgpool-II-pg14-4.4.17-nes-minimal-rhel7.tar.gz
Oracle Linux 7pgpool-II-pg14-4.4.17-nes-minimal-oraclelinux7.tar.gz

Download NES for pgpool-II for your platform

The example below downloads the standard RHEL 9 build; substitute the filename and version from the tables above for other platforms or the minimal build.

curl -fSL -u "<your-contact-email>:<your-nes-access-token>" \
  -o pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz \
  "https://registry.nes.herodevs.com/bin/nes/pgpool/4.5.12/pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz"

Verify and extract

Download the .sha256 sidecar from the same registry path, verify, then extract.

curl -fSL -u "<your-contact-email>:<your-nes-access-token>" \
  -o pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz.sha256 \
  "https://registry.nes.herodevs.com/bin/nes/pgpool/4.5.12/pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz.sha256"
sha256sum -c pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz.sha256
tar -xzf pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz -C /opt/nes

Configure pgpool-II

Point pgpool-II at your NES for PostgreSQL 14 backends and start the pooler. Refer to the upstream pgpool-II 4.5 documentation for connection pooling, load balancing, and high-availability configuration.