How To Install pgbouncer on CentOS 8
Introduction
In this tutorial we learn how to install pgbouncer on CentOS 8.
What is pgbouncer
pgbouncer is a lightweight connection pooler for PostgreSQL and uses libevent for low-level socket handling.
We can use yum or dnf to install pgbouncer on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install pgbouncer.
Install pgbouncer on CentOS 8 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install pgbouncer using dnf by running the following command:
sudo dnf -y install pgbouncer
Install pgbouncer on CentOS 8 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install pgbouncer using yum by running the following command:
sudo yum -y install pgbouncer
How To Uninstall pgbouncer on CentOS 8
To uninstall only the pgbouncer package we can use the following command:
sudo dnf remove pgbouncer
pgbouncer Package Contents on CentOS 8
/etc/logrotate.d/pgbouncer
/etc/pam.d/pgbouncer
/etc/pgbouncer
/etc/pgbouncer/mkauth.py
/etc/pgbouncer/pgbouncer.ini
/etc/pgbouncer/userlist.txt
/etc/sysconfig/pgbouncer
/run/pgbouncer
/run/pgbouncer/pgbouncer.pid
/usr/bin/pgbouncer
/usr/lib/.build-id
/usr/lib/.build-id/cf
/usr/lib/.build-id/cf/3097468ce1b6ef6f04c1b4fdfc25f9afc388ab
/usr/lib/systemd/system/pgbouncer.service
/usr/lib/tmpfiles.d/pgbouncer.conf
/usr/share/doc/pgbouncer
/usr/share/doc/pgbouncer/NEWS.md
/usr/share/doc/pgbouncer/README.md
/usr/share/doc/pgbouncer/config.md
/usr/share/doc/pgbouncer/frag-config-man.md
/usr/share/doc/pgbouncer/frag-usage-man.md
/usr/share/doc/pgbouncer/usage.md
/usr/share/licenses/pgbouncer
/usr/share/licenses/pgbouncer/COPYRIGHT
/usr/share/man/man1/pgbouncer.1.gz
/usr/share/man/man5/pgbouncer.5.gz
/var/log/pgbouncer
References
Summary
In this tutorial we learn how to install pgbouncer on CentOS 8 using yum and dnf.