pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is licensed under BSD license. It provides the following features – Connection Pooling, Replication Load Balancing, Limiting Exceeding Connections.
Enable snaps on Raspberry Pi and install postgresql95-pgpool2-36
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
Enable snapd
On a Raspberry Pi running the latest version of Raspbian snap can be installed directly from the command line:
sudo apt update
sudo apt install snapd
You will also need to reboot your device:
sudo reboot
After this, install the snapd snap in order to get the latest snapd:
sudo snap install snapd
Install postgresql95-pgpool2-36
To install postgresql95-pgpool2-36, simply use the following command: