https://dl.marmotte.net/rpms/redhat/el8/x86_64/libbsd-0.9.1-4.el8/
https://ftp.postgresql.org/pub/repos/yum/common/redhat/rhel-8.2-x86_64/
[root@localhost ~]# yum install pg_top
Last metadata expiration check: 0:38:49 ago on Tue 24 Feb 2026 06:50:29 AM UTC.
Error:
Problem: cannot install the best candidate for the job
- nothing provides libbsd.so.0()(64bit) needed by pg_top-4.1.2-42PGDG.rhel8.x86_64 from pgdg-common
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[root@localhost ~]# dnf install epel-release
Last metadata expiration check: 0:40:19 ago on Tue 24 Feb 2026 06:50:29 AM UTC.
Dependencies resolved.
================================================================================================================================================================================
Package Architecture Version Repository Size
================================================================================================================================================================================
Installing:
oracle-epel-release-el8 x86_64 1.0-5.el8 ol8_baseos_latest 15 k
Installing dependencies:
yum-utils noarch 4.0.21-25.0.1.el8 ol8_baseos_latest 75 k
Transaction Summary
================================================================================================================================================================================
Install 2 Packages
Total download size: 90 k
Installed size: 41 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): oracle-epel-release-el8-1.0-5.el8.x86_64.rpm 163 kB/s | 15 kB 00:00
(2/2): yum-utils-4.0.21-25.0.1.el8.noarch.rpm 732 kB/s | 75 kB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 707 kB/s | 90 kB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : yum-utils-4.0.21-25.0.1.el8.noarch 1/2
Installing : oracle-epel-release-el8-1.0-5.el8.x86_64 2/2
Running scriptlet: oracle-epel-release-el8-1.0-5.el8.x86_64 2/2
Verifying : oracle-epel-release-el8-1.0-5.el8.x86_64 1/2
Verifying : yum-utils-4.0.21-25.0.1.el8.noarch 2/2
Installed:
oracle-epel-release-el8-1.0-5.el8.x86_64 yum-utils-4.0.21-25.0.1.el8.noarch
Complete!
[root@localhost ~]# dnf install pg_top
Oracle Linux 8 EPEL Packages for Development (x86_64) [ === ] --- B/s | 0 B --:-- ETA
Oracle Linux 8 EPEL Packages for Development (x86_64) 0.0 B/s | 0 B 07:58
Errors during downloading metadata for repository 'ol8_developer_EPEL':
- Curl error (7): Couldn't connect to server for https://yum.us-phoenix-1.oci.oraclecloud.com/repo/OracleLinux/OL8/developer/EPEL/x86_64/repodata/repomd.xml [Failed to connect to yum.us-phoenix-1.oci.oraclecloud.com port 443: Connection timed out]
Error: Failed to download metadata for repo 'ol8_developer_EPEL': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# cd /root/
[root@localhost ~]# ls -ltr
total 204
-rw-------. 1 root root 5142 Oct 20 13:41 anaconda-ks.cfg
-rw-------. 1 root root 4948 Oct 20 13:45 ks-post.log
-rw-------. 1 root root 5432 Oct 20 13:45 original-ks.cfg
-rw-r--r--. 1 root root 128 Oct 20 14:49 log2947
-rw-r--r--. 1 root root 281 Oct 20 14:53 log2894
-rw-r--r--. 1 root root 63444 Feb 24 07:38 pg_top-4.1.2-42PGDG.rhel8.x86_64.rpm
-rw-r--r--. 1 root root 106984 Feb 24 08:16 libbsd-0.9.1-4.el8.x86_64.rpm
[root@localhost ~]# yum -y localinstall /root/libbsd-0.9.1-4.el8.x86_64.rpm
Oracle Linux 8 EPEL Packages for Development (x86_64) 0.0 B/s | 0 B 07:58
Errors during downloading metadata for repository 'ol8_developer_EPEL':
- Curl error (7): Couldn't connect to server for https://yum.us-phoenix-1.oci.oraclecloud.com/repo/OracleLinux/OL8/developer/EPEL/x86_64/repodata/repomd.xml [Failed to connect to yum.us-phoenix-1.oci.oraclecloud.com port 443: Connection timed out]
Error: Failed to download metadata for repo 'ol8_developer_EPEL': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@localhost ~]# yum config-manager --disable ol8_developer_EPEL
[root@localhost ~]# yum -y localinstall /root/libbsd-0.9.1-4.el8.x86_64.rpm
^COracle Linux 8 EPEL Modular Packages for Development (x86_64) [ === ] --- B/s | 0 B --:-- ETOracle Linux 8 EPEL Modular Packages for Development (x86_64) 0.0 B/s | 0 B 00:12
Error: Failed to download metadata for repo 'ol8_developer_EPEL_modular': Librepo was interrupted by a signal
[root@localhost ~]# rpm -ivh /root/libbsd-0.9.1-4.el8.x86_64.rpm
warning: /root/libbsd-0.9.1-4.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID e755cc63: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:libbsd-0.9.1-4.el8 ################################# [100%]
[root@localhost ~]# rpm -ivh /root/pg_top-4.1.2-42PGDG.rhel8.x86_64.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:pg_top-4.1.2-42PGDG.rhel8 ################################# [100%]
[root@localhost ~]# pg_top --version
pg_top 4.1.2
[root@localhost ~]#
[root@localhost ~]# ps -ef|grep -i postgres
postgres 1080 1 0 05:38 ? 00:00:01 /usr/pgsql-17/bin/postgres -D /var/lib/pgsql/17/data/
postgres 1131 1080 0 05:38 ? 00:00:00 postgres: logger
postgres 1143 1080 0 05:38 ? 00:00:00 postgres: checkpointer
postgres 1144 1080 0 05:38 ? 00:00:00 postgres: background writer
postgres 1158 1080 0 05:38 ? 00:00:00 postgres: walwriter
postgres 1159 1080 0 05:38 ? 00:00:00 postgres: autovacuum launcher
postgres 1160 1080 0 05:38 ? 00:00:00 postgres: logical replication launcher
root 9513 3877 0 08:33 pts/2 00:00:00 grep --color=auto -i postgres
[root@localhost ~]#
pg_top -h localhost -p 5432 -U postgres -d postgres
output ---
pg_top -h localhost -p 5432 -U postgres -d postgres
[root@localhost ~]# pg_top -W -U postgres -d postgres <<<< this will prompt passwd
Password:
[root@localhost ~]# export PGPASSWORD='postgres'
[root@localhost ~]# pg_top -W -U postgres -d postgres
Password:
[root@localhost ~]# pg_top -h localhost -p 5432 -U postgres -d postgres
output ---
last pid: 9909; load avg: 0.61, 0.65, 0.64; up 0+03:07:42 08:45:01
6 processes: 5 other background task(s), 1 active
CPU states: 3.2% user, 0.0% nice, 4.5% system, 91.6% idle, 0.7% iowait
Memory: 3706M used, 202M free, 0K shared, 4K buffers, 1922M cached
DB activity: 0 tps, 0 rollbs/s, 0 buffer r/s, 100 hit%, 3 row r/s, 0 row w/s
DB I/O: 0 reads/s, 1 KB/s, 3 writes/s, 29 KB/s
Swap: 775M used, 3321M free, 24M cached, 0K in, 0K out
PID USERNAME SIZE RES STATE XTIME QTIME %CPU LOCKS COMMAND
9904 postgres 492M 18M active 0:00 0:00 0.2 8 postgres: postgres postgres [local] idle
1143 489M 6580K 0:00 0:00 0.0 0 postgres: checkpointer
1158 489M 8704K 0:00 0:00 0.0 0 postgres: walwriter
1144 489M 4980K 0:00 0:00 0.0 0 postgres: background writer
1159 490M 7476K 0:00 0:00 0.0 0 postgres: autovacuum launcher
1160 postgres 490M 7732K 0:00 0:00 0.0 0 postgres: logical replication launcher
Tuesday, 24 February 2026
postgres how to install pg_top
Subscribe to:
Comments (Atom)
