How To Install pgcenter on Fedora 36

In this tutorial we learn how to install pgcenter in Fedora 36. pgcenter is Top-like PostgreSQL statistics viewer

Introduction

In this tutorial we learn how to install pgcenter on Fedora 36.

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 36. In this tutorial we discuss both methods but you only need to choose one of method to install pgcenter.

Install pgcenter 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 pgcenter using dnf by running the following command:

sudo dnf -y install pgcenter

Install pgcenter 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 pgcenter using yum by running the following command:

sudo yum -y install pgcenter

How To Uninstall pgcenter on Fedora 36

To uninstall only the pgcenter package we can use the following command:

sudo dnf remove pgcenter

pgcenter Package Contents on Fedora 36

/usr/bin/pgcenter
/usr/lib/.build-id
/usr/lib/.build-id/22
/usr/lib/.build-id/22/09d5e2a590175e411c5f4ec4c5893612b80914
/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 36 using yum and [dnf]((/fedora/36/dnf/).