How To Install postgresql-pgpool-II on CentOS 7
Introduction
In this tutorial we learn how to install postgresql-pgpool-II on CentOS 7.
What is postgresql-pgpool-II
pgpool-II is a inherited project of pgpool (to classify from pgpool-II, it is sometimes called as pgpool-I). For those of you not familiar with pgpool-I, it is a multi-functional middle ware for PostgreSQL that features connection pooling, replication and load balancing functions. pgpool-I allows a user to connect at most two PostgreSQL servers for higher availability or for higher search performance compared to a single PostgreSQL server. pgpool-II, on the other hand, allows multiple PostgreSQL servers (DB nodes) to be connected, which enables queries to be executed simultaneously on all servers. In other words, it enables “parallel query” processing. Also, pgpool-II can be started as pgpool-I by changing configuration parameters. pgpool-II that is executed in pgpool-I mode enables multiple DB nodes to be connected, which was not possible in pgpool-I.
We can use yum or dnf to install postgresql-pgpool-II on CentOS 7. In this tutorial we discuss both methods but you only need to choose one of method to install postgresql-pgpool-II.
Install postgresql-pgpool-II on CentOS 7 Using yum
Update yum database with yum using the following command.
sudo yum makecache
After updating yum database, We can install postgresql-pgpool-II using yum by running the following command:
sudo yum -y install postgresql-pgpool-II
Install postgresql-pgpool-II on CentOS 7 Using dnf
If you don’t have dnf installed you can install DNF on CentOS 7 first.
Update yum database with dnf using the following command.
sudo dnf makecache
After updating yum database, We can install postgresql-pgpool-II using dnf by running the following command:
sudo dnf -y install postgresql-pgpool-II
How To Uninstall postgresql-pgpool-II on CentOS 7
To uninstall only the postgresql-pgpool-II package we can use the following command:
sudo dnf remove postgresql-pgpool-II
References
Summary
In this tutorial we learn how to install postgresql-pgpool-II on CentOS 7 using yum and dnf.
