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.
After updating yum database, We can install postgresql-pgpool-II
using yum
by running the following command:
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.
After updating yum database, We can install postgresql-pgpool-II
using dnf
by running the following command:
How To Uninstall postgresql-pgpool-II on CentOS 7
To uninstall only the postgresql-pgpool-II
package we can use the following command:
References
Summary
In this tutorial we learn how to install postgresql-pgpool-II
on CentOS 7 using yum
and dnf
.