How To Install pgcenter on CentOS 7
Introduction
In this tutorial we learn how to install pgcenter on CentOS 7.
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 CentOS 7. In this tutorial we discuss both methods but you only need to choose one of method to install pgcenter.
Install pgcenter on CentOS 7 Using yum
Update yum database with yum using the following command.
sudo yum makecache
After updating yum database, We can install pgcenter using yum by running the following command:
sudo yum -y install pgcenter
Install pgcenter on CentOS 7 Using dnf
If you don’t have dnf installed you can install DNF on CentOS 7 first.
Update yum database with dnf using the following command.
sudo dnf makecache
After updating yum database, We can install pgcenter using dnf by running the following command:
sudo dnf -y install pgcenter
How To Uninstall pgcenter on CentOS 7
To uninstall only the pgcenter package we can use the following command:
sudo dnf remove pgcenter
References
Summary
In this tutorial we learn how to install pgcenter on CentOS 7 using yum and dnf.
