PgPool II Installation
Start by getting the rpm for version 3.4.3 for CentOS 7. If you need some other version you can go here.
Open a terminal, change to the directory where you downloaded the rpm file and run:
sudo yum localinstall file.rpm (of course change file.rpm to the actual filename)
There's a useful command, pcp, that we use to configure and monitor PgPool II but we must first create a user and password for it:
-
On a terminal do
pcp_md5 mypassword(use whatever password you want) and copy the output. -
Open the file
/etc/pgpool-II/pcp.confand create a new line at the end with username:md5password, for example myuser:34819d7beeabb9260a5c854bc85b3e44
