How To Install pgcenter on Fedora 34
Introduction
In this tutorial we learn how to install pgcenter on Fedora 34.
What is pgcenter
PostgreSQL provides various statistics which includes information about tables, indexes, functions and other database objects and their usage. Moreover, statistics has detailed information about connections, current queries and database operations (INSERT/DELETE/UPDATE). But most of this statistics are provided as permanently incremented counters. The pgcenter provides convenient interface to this statistics and allow viewing statistics changes in time interval, e.g. per second. The pgcenter provides fast access for database management task, such as editing configuration files, reloading services, viewing log files and canceling or terminating database backends (by pid or using state mask). However if need execute some specific operations, pgcenter can start psql session for this purposes.
We can use yum or dnf to install pgcenter on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install pgcenter.
Install pgcenter on Fedora 34 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
Fedora 34 - x86_64 20 kB/s | 6.6 kB 00:00
Fedora 34 openh264 (From Cisco) - x86_64 1.4 kB/s | 989 B 00:00
Fedora Modular 34 - x86_64 68 kB/s | 6.5 kB 00:00
Fedora 34 - x86_64 - Updates 3.5 kB/s | 6.2 kB 00:01
Fedora Modular 34 - x86_64 - Updates 17 kB/s | 5.9 kB 00:00
Metadata cache created.
After updating yum database, We can install pgcenter using dnf by running the following command:
sudo dnf -y install pgcenter
Install pgcenter on Fedora 34 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
Fedora 34 - x86_64 20 kB/s | 6.6 kB 00:00
Fedora 34 openh264 (From Cisco) - x86_64 1.4 kB/s | 989 B 00:00
Fedora Modular 34 - x86_64 68 kB/s | 6.5 kB 00:00
Fedora 34 - x86_64 - Updates 3.5 kB/s | 6.2 kB 00:01
Fedora Modular 34 - x86_64 - Updates 17 kB/s | 5.9 kB 00:00
Metadata cache created.
After updating yum database, We can install pgcenter using yum by running the following command:
sudo yum -y install pgcenter
How To Uninstall pgcenter on Fedora 34
To uninstall only the pgcenter package we can use the following command:
sudo dnf remove pgcenter
pgcenter Package Contents on Fedora 34
/usr/bin/pgcenter
/usr/lib/.build-id
/usr/lib/.build-id/75
/usr/lib/.build-id/75/de99483ff6735beef8b99334e143354f63b278
/usr/share/doc/pgcenter
/usr/share/doc/pgcenter/Changelog
/usr/share/doc/pgcenter/README.md
/usr/share/licenses/pgcenter
/usr/share/licenses/pgcenter/COPYRIGHT
/usr/share/man/man1/pgcenter.1.gz
References
Summary
In this tutorial we learn how to install pgcenter on Fedora 34 using yum and dnf.