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
| Platform | pgpool-II version |
|---|---|
| Most supported platforms | 4.5.12 |
| RHEL 7, Oracle Linux 7 | 4.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
| Platform | Architecture |
|---|---|
| RHEL / UBI 7, 8, 9, 10 | x86_64 |
| Oracle Linux 7, 8, 9, 10 | x86_64 |
| SLES 12 SP5, 15 SP3 | x86_64 |
| AIX 7.2 TL5 | ppc64 |
| Solaris 11.4 | x86_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)
| Platform | Filename |
|---|---|
| RHEL / UBI 8 | pgpool-II-pg14-4.5.12-nes-rhel8.tar.gz |
| RHEL / UBI 9 | pgpool-II-pg14-4.5.12-nes-rhel9.tar.gz |
| RHEL / UBI 10 | pgpool-II-pg14-4.5.12-nes-rhel10.tar.gz |
| Oracle Linux 8 | pgpool-II-pg14-4.5.12-nes-oraclelinux8.tar.gz |
| Oracle Linux 9 | pgpool-II-pg14-4.5.12-nes-oraclelinux9.tar.gz |
| Oracle Linux 10 | pgpool-II-pg14-4.5.12-nes-oraclelinux10.tar.gz |
| SLES 12 SP5 | pgpool-II-pg14-4.5.12-nes-sles-12sp5.tar.gz |
| SLES 15 SP3 | pgpool-II-pg14-4.5.12-nes-sles-15sp3.tar.gz |
| AIX 7.2 TL5 | pgpool-II-pg14-4.5.12-nes-aix-7.2-tl5-ppc64.tar.gz |
| Solaris 11.4 x86_64 | pgpool-II-pg14-4.5.12-nes-solaris-11.4-x86_64.tar.gz |
| Solaris 11.4 SPARC64 | pgpool-II-pg14-4.5.12-nes-solaris-11.4-sparc64.tar.gz |
| RHEL / UBI 7 | pgpool-II-pg14-4.4.17-nes-rhel7.tar.gz |
| Oracle Linux 7 | pgpool-II-pg14-4.4.17-nes-oraclelinux7.tar.gz |
Minimal build (4.5.12)
| Platform | Filename |
|---|---|
| RHEL / UBI 8 | pgpool-II-pg14-4.5.12-nes-minimal-rhel8.tar.gz |
| RHEL / UBI 9 | pgpool-II-pg14-4.5.12-nes-minimal-rhel9.tar.gz |
| RHEL / UBI 10 | pgpool-II-pg14-4.5.12-nes-minimal-rhel10.tar.gz |
| Oracle Linux 8 | pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux8.tar.gz |
| Oracle Linux 9 | pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux9.tar.gz |
| Oracle Linux 10 | pgpool-II-pg14-4.5.12-nes-minimal-oraclelinux10.tar.gz |
| SLES 12 SP5 | pgpool-II-pg14-4.5.12-nes-minimal-sles-12sp5.tar.gz |
| SLES 15 SP3 | pgpool-II-pg14-4.5.12-nes-minimal-sles-15sp3.tar.gz |
| AIX 7.2 TL5 | pgpool-II-pg14-4.5.12-nes-minimal-aix-7.2-tl5-ppc64.tar.gz |
| Solaris 11.4 x86_64 | pgpool-II-pg14-4.5.12-nes-minimal-solaris-11.4-x86_64.tar.gz |
| Solaris 11.4 SPARC64 | pgpool-II-pg14-4.5.12-nes-minimal-solaris-11.4-sparc64.tar.gz |
| RHEL / UBI 7 | pgpool-II-pg14-4.4.17-nes-minimal-rhel7.tar.gz |
| Oracle Linux 7 | pgpool-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.