How To Install postgresql-pgpool-II on Fedora 36

In this tutorial we learn how to install postgresql-pgpool-II in Fedora 36. postgresql-pgpool-II is Pgpool is a connection pooling/replication server for PostgreSQL

Introduction

In this tutorial we learn how to install postgresql-pgpool-II on Fedora 36.

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 Fedora 36. 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 Fedora 36 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install postgresql-pgpool-II using dnf by running the following command:

sudo dnf -y install postgresql-pgpool-II

Install postgresql-pgpool-II on Fedora 36 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install postgresql-pgpool-II using yum by running the following command:

sudo yum -y install postgresql-pgpool-II

How To Uninstall postgresql-pgpool-II on Fedora 36

To uninstall only the postgresql-pgpool-II package we can use the following command:

sudo dnf remove postgresql-pgpool-II

postgresql-pgpool-II Package Contents on Fedora 36

/etc/pgpool-II
/etc/pgpool-II/escalation.sh.sample
/etc/pgpool-II/failover.sh
/etc/pgpool-II/follow_primary.sh.sample
/etc/pgpool-II/pcp.conf
/etc/pgpool-II/pgpool.conf
/etc/pgpool-II/pgpool.conf.sample-logical
/etc/pgpool-II/pgpool.conf.sample-raw
/etc/pgpool-II/pgpool.conf.sample-slony
/etc/pgpool-II/pgpool.conf.sample-snapshot
/etc/pgpool-II/pgpool_remote_start
/etc/pgpool-II/pool_hba.conf
/etc/pgpool-II/recovery_1st_stage
/etc/pgpool-II/recovery_2nd_stage.sample
/etc/sysconfig/pgpool
/usr/bin/pcp_attach_node
/usr/bin/pcp_detach_node
/usr/bin/pcp_health_check_stats
/usr/bin/pcp_node_count
/usr/bin/pcp_node_info
/usr/bin/pcp_pool_status
/usr/bin/pcp_proc_count
/usr/bin/pcp_proc_info
/usr/bin/pcp_promote_node
/usr/bin/pcp_recovery_node
/usr/bin/pcp_reload_config
/usr/bin/pcp_stop_pgpool
/usr/bin/pcp_watchdog_info
/usr/bin/pg_enc
/usr/bin/pg_md5
/usr/bin/pgpool
/usr/bin/pgpool_setup
/usr/bin/pgproto
/usr/bin/watchdog_setup
/usr/bin/wd_cli
/usr/lib/.build-id
/usr/lib/.build-id/08
/usr/lib/.build-id/08/3490133e63e8ab306d13cb8f529deb83261895
/usr/lib/.build-id/48
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.1
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.10
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.11
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.2
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.3
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.4
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.5
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.6
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.7
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.8
/usr/lib/.build-id/48/655355fbd1c62c4035844e13fb3da04db9bbb4.9
/usr/lib/.build-id/66
/usr/lib/.build-id/66/6248c3194335fb7b8ed4a26b97db4904d9543d
/usr/lib/.build-id/74
/usr/lib/.build-id/74/90cc622f918d2b8fc617d4582aac06746dc683
/usr/lib/.build-id/7d
/usr/lib/.build-id/7d/e01bbf45b618ccb0bc201ba3771bea957beb4b
/usr/lib/.build-id/96
/usr/lib/.build-id/96/254075c68f313ccb30b510ab5b75830068c2ce
/usr/lib/.build-id/ad
/usr/lib/.build-id/ad/fcd18b26932d628da8f9f76a6310e660f5ecb6
/usr/lib/.build-id/cc
/usr/lib/.build-id/cc/be7d9acc8e19be397f6664b1a66cafa4137de1
/usr/lib/systemd/system/pgpool.service
/usr/lib/tmpfiles.d/postgresql-pgpool-II.conf
/usr/lib64/libpcp.so.2
/usr/lib64/libpcp.so.2.0.0
/usr/share/doc/postgresql-pgpool-II
/usr/share/doc/postgresql-pgpool-II/AUTHORS
/usr/share/doc/postgresql-pgpool-II/COPYING
/usr/share/doc/postgresql-pgpool-II/ChangeLog
/usr/share/doc/postgresql-pgpool-II/NEWS
/usr/share/doc/postgresql-pgpool-II/README
/usr/share/doc/postgresql-pgpool-II/TODO
/usr/share/pgpool-II
/usr/share/pgpool-II/insert_lock.sql
/usr/share/pgpool-II/pgpool.conf.sample-replication
/usr/share/pgpool-II/pgpool.conf.sample-stream
/usr/share/pgpool-II/pgpool.pam
/var/run/pgpool

References

Summary

In this tutorial we learn how to install postgresql-pgpool-II on Fedora 36 using yum and [dnf]((/fedora/36/dnf/).

title: “How To Install postgresql-pgpool-II on Fedora 36” linkTitle: “postgresql-pgpool-II” type: “docs” description: “In this tutorial we learn how to install postgresql-pgpool-II in Fedora 36. postgresql-pgpool-II is Pgpool is a connection pooling/replication server for PostgreSQL” date: “2022-08-17” lastmod: “2022-08-17” #image: /images/fedora/36/postgresql-pgpool-II-featured.png

Introduction

In this tutorial we learn how to install postgresql-pgpool-II on Fedora 36.

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 Fedora 36. 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 Fedora 36 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install postgresql-pgpool-II using dnf by running the following command:

sudo dnf -y install postgresql-pgpool-II

Install postgresql-pgpool-II on Fedora 36 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install postgresql-pgpool-II using yum by running the following command:

sudo yum -y install postgresql-pgpool-II

How To Uninstall postgresql-pgpool-II on Fedora 36

To uninstall only the postgresql-pgpool-II package we can use the following command:

sudo dnf remove postgresql-pgpool-II

postgresql-pgpool-II Package Contents on Fedora 36

/etc/pgpool-II
/etc/pgpool-II/escalation.sh.sample
/etc/pgpool-II/failover.sh
/etc/pgpool-II/follow_primary.sh.sample
/etc/pgpool-II/pcp.conf
/etc/pgpool-II/pgpool.conf
/etc/pgpool-II/pgpool.conf.sample-logical
/etc/pgpool-II/pgpool.conf.sample-raw
/etc/pgpool-II/pgpool.conf.sample-slony
/etc/pgpool-II/pgpool.conf.sample-snapshot
/etc/pgpool-II/pgpool_remote_start
/etc/pgpool-II/pool_hba.conf
/etc/pgpool-II/recovery_1st_stage
/etc/pgpool-II/recovery_2nd_stage.sample
/etc/sysconfig/pgpool
/usr/bin/pcp_attach_node
/usr/bin/pcp_detach_node
/usr/bin/pcp_health_check_stats
/usr/bin/pcp_node_count
/usr/bin/pcp_node_info
/usr/bin/pcp_pool_status
/usr/bin/pcp_proc_count
/usr/bin/pcp_proc_info
/usr/bin/pcp_promote_node
/usr/bin/pcp_recovery_node
/usr/bin/pcp_reload_config
/usr/bin/pcp_stop_pgpool
/usr/bin/pcp_watchdog_info
/usr/bin/pg_enc
/usr/bin/pg_md5
/usr/bin/pgpool
/usr/bin/pgpool_setup
/usr/bin/pgproto
/usr/bin/watchdog_setup
/usr/bin/wd_cli
/usr/lib/.build-id
/usr/lib/.build-id/15
/usr/lib/.build-id/15/f8236d1103bc5bc97ea7c487adc39b0ddb6032
/usr/lib/.build-id/1c
/usr/lib/.build-id/1c/664e0bba58b28c7e8b5a63a85e14707be27ca4
/usr/lib/.build-id/58
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.1
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.10
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.11
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.2
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.3
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.4
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.5
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.6
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.7
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.8
/usr/lib/.build-id/58/a63c2d7a6cccba338fb71f3734539fc45688c3.9
/usr/lib/.build-id/61
/usr/lib/.build-id/61/131b8abd9b076315e686319c8e2a3e661f6783
/usr/lib/.build-id/8b
/usr/lib/.build-id/8b/f5cff57eee95fde0e13af5ab2b74ffc2a01ef5
/usr/lib/.build-id/91
/usr/lib/.build-id/91/2a49d0ec1bbcd9059612756bbd601cd63a70e0
/usr/lib/.build-id/df
/usr/lib/.build-id/df/5b83363af390746d6a7ee23bf883d46a09d74e
/usr/lib/.build-id/eb
/usr/lib/.build-id/eb/e6e17074ca11c4c7a0f97d478b3e3870b508f1
/usr/lib/libpcp.so.2
/usr/lib/libpcp.so.2.0.0
/usr/lib/systemd/system/pgpool.service
/usr/lib/tmpfiles.d/postgresql-pgpool-II.conf
/usr/share/doc/postgresql-pgpool-II
/usr/share/doc/postgresql-pgpool-II/AUTHORS
/usr/share/doc/postgresql-pgpool-II/COPYING
/usr/share/doc/postgresql-pgpool-II/ChangeLog
/usr/share/doc/postgresql-pgpool-II/NEWS
/usr/share/doc/postgresql-pgpool-II/README
/usr/share/doc/postgresql-pgpool-II/TODO
/usr/share/pgpool-II
/usr/share/pgpool-II/insert_lock.sql
/usr/share/pgpool-II/pgpool.conf.sample-replication
/usr/share/pgpool-II/pgpool.conf.sample-stream
/usr/share/pgpool-II/pgpool.pam
/var/run/pgpool

References

Summary

In this tutorial we learn how to install postgresql-pgpool-II on Fedora 36 using yum and [dnf]((/fedora/36/dnf/).