< Home - < Back

postgresql-pgpool-II


Information about the package, postgresql-pgpool-II, which is shipped with common Linux distributions. The postgresql-pgpool-II package is designed for, Pgpool is a connection pooling/replication server for PostgreSQL.


Package Name:

postgresql-pgpool-II

Summary:

Pgpool is a connection pooling/replication server for PostgreSQL

Description:

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.

Architecture:

x86_64

Version:

3.2.15

Release:

1.el6

Size:

560 k

Repository:

epel

From Repository:

Licence:

BSD



Handy Yum Commands for postgresql-pgpool-II


Control the postgresql-pgpool-II package with the following handy commands outlined below.


Command

Description of Command

yum install postgresql-pgpool-II

This command will install postgresql-pgpool-II on the server.

yum remove postgresql-pgpool-II

This command will un-install postgresql-pgpool-II on the server. When you run this command, you will be asked if you are sure that you want to remove postgresql-pgpool-II, so you have to manually confirm that you want to do this.

yum -y remove postgresql-pgpool-II

This command will un-install postgresql-pgpool-II on the server. When you run this command with th e -y flag, you will not be prompted to check that you are sure you want to remove the package - so be sure you absolutely want to remove postgresql-pgpool-II when using the -y flag.

yum update postgresql-pgpool-II

This command will update postgresql-pgpool-II to the latest version. When you run this command, you will be asked if you are sure that you want to remove postgresql-pgpool-II, so you have to manually confirm that you want to do this.

yum -y update postgresql-pgpool-II

This command will update postgresql-pgpool-II to the latest version. When you run this command with the -y flag, you will not be prompted to check that you are sure you want to remove the package - so be sure you absolutely want to remove postgresql-pgpool-II when using the -y flag.

yum info postgresql-pgpool-II

This command will show you core information about the postgresql-pgpool-II package.

yum deplist postgresql-pgpool-II

This command will show you the dependencies for postgresql-pgpool-II. Thankfully, when using Yum, if dependencies are required, these are also installed at the same time so you don't have to worry too much about that.

yum check-update postgresql-pgpool-II

This command will check if there is an update waiting on postgresql-pgpool-II. When you run this command this will return nothing if there is nothing to update, or, will return the package name if the package is due to be updated.