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.
After updating yum database, We can install pgcenter
using yum
by running the following command:
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.
After updating yum database, We can install pgcenter
using dnf
by running the following command:
How To Uninstall pgcenter on CentOS 7
To uninstall only the pgcenter
package we can use the following command:
References
Summary
In this tutorial we learn how to install pgcenter
on CentOS 7 using yum
and dnf
.