How To Install pg_activity on Fedora 34
pg_activity is Command line tool for PostgreSQL server activity monitoring
Introduction
In this tutorial we learn how to install pg_activity on Fedora 34.
What is pg_activity
Top like application for PostgreSQL server activity monitoring
We can use yum or dnf to install pg_activity on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install pg_activity.
Install pg_activity 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 pg_activity using dnf by running the following command:
sudo dnf -y install pg_activity
Install pg_activity 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 pg_activity using yum by running the following command:
sudo yum -y install pg_activity
How To Uninstall pg_activity on Fedora 34
To uninstall only the pg_activity package we can use the following command:
sudo dnf remove pg_activity
pg_activity Package Contents on Fedora 34
/usr/bin/pg_activity
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/PKG-INFO
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/SOURCES.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/dependency_links.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/entry_points.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/requires.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.3-py3.9.egg-info/top_level.txt
/usr/lib/python3.9/site-packages/pgactivity
/usr/lib/python3.9/site-packages/pgactivity/__init__.py
/usr/lib/python3.9/site-packages/pgactivity/__main__.py
/usr/lib/python3.9/site-packages/pgactivity/__pycache__
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__init__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__init__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__main__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__main__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/activities.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/activities.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/cli.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/cli.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/colors.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/colors.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/compat.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/compat.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/data.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/data.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/handlers.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/handlers.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/keys.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/keys.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/types.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/types.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/ui.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/ui.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/utils.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/utils.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/views.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/views.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/widgets.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/widgets.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/activities.py
/usr/lib/python3.9/site-packages/pgactivity/cli.py
/usr/lib/python3.9/site-packages/pgactivity/colors.py
/usr/lib/python3.9/site-packages/pgactivity/compat.py
/usr/lib/python3.9/site-packages/pgactivity/data.py
/usr/lib/python3.9/site-packages/pgactivity/handlers.py
/usr/lib/python3.9/site-packages/pgactivity/keys.py
/usr/lib/python3.9/site-packages/pgactivity/queries
/usr/lib/python3.9/site-packages/pgactivity/queries/__init__.py
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__/__init__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__/__init__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/queries/disable_log_min_duration_sample.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/disable_log_min_duration_statement.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/do_pg_cancel_backend.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/do_pg_terminate_backend.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_active_connections.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_active_connections_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_blocking.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_blocking_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_db_info.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_100000.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_110000.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_90600.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pga_inet_addresses.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pid_file.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_version.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_waiting.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_waiting_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/is_superuser.sql
/usr/lib/python3.9/site-packages/pgactivity/types.py
/usr/lib/python3.9/site-packages/pgactivity/ui.py
/usr/lib/python3.9/site-packages/pgactivity/utils.py
/usr/lib/python3.9/site-packages/pgactivity/views.py
/usr/lib/python3.9/site-packages/pgactivity/widgets.py
/usr/share/doc/pg_activity
/usr/share/doc/pg_activity/AUTHORS.md
/usr/share/doc/pg_activity/README.md
/usr/share/licenses/pg_activity
/usr/share/licenses/pg_activity/LICENSE.txt
/usr/bin/pg_activity
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/PKG-INFO
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/SOURCES.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/dependency_links.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/entry_points.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/requires.txt
/usr/lib/python3.9/site-packages/pg_activity-2.1.4-py3.9.egg-info/top_level.txt
/usr/lib/python3.9/site-packages/pgactivity
/usr/lib/python3.9/site-packages/pgactivity/__init__.py
/usr/lib/python3.9/site-packages/pgactivity/__main__.py
/usr/lib/python3.9/site-packages/pgactivity/__pycache__
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__init__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__init__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__main__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/__main__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/activities.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/activities.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/cli.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/cli.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/colors.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/colors.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/compat.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/compat.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/data.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/data.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/handlers.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/handlers.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/keys.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/keys.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/types.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/types.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/ui.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/ui.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/utils.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/utils.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/views.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/views.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/widgets.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/__pycache__/widgets.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/activities.py
/usr/lib/python3.9/site-packages/pgactivity/cli.py
/usr/lib/python3.9/site-packages/pgactivity/colors.py
/usr/lib/python3.9/site-packages/pgactivity/compat.py
/usr/lib/python3.9/site-packages/pgactivity/data.py
/usr/lib/python3.9/site-packages/pgactivity/handlers.py
/usr/lib/python3.9/site-packages/pgactivity/keys.py
/usr/lib/python3.9/site-packages/pgactivity/queries
/usr/lib/python3.9/site-packages/pgactivity/queries/__init__.py
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__/__init__.cpython-39.opt-1.pyc
/usr/lib/python3.9/site-packages/pgactivity/queries/__pycache__/__init__.cpython-39.pyc
/usr/lib/python3.9/site-packages/pgactivity/queries/disable_log_min_duration_sample.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/disable_log_min_duration_statement.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/do_pg_cancel_backend.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/do_pg_terminate_backend.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_active_connections.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_active_connections_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_blocking.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_blocking_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_db_info.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_100000.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_110000.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pg_activity_post_90600.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pga_inet_addresses.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_pid_file.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_version.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_waiting.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/get_waiting_post_90200.sql
/usr/lib/python3.9/site-packages/pgactivity/queries/is_superuser.sql
/usr/lib/python3.9/site-packages/pgactivity/types.py
/usr/lib/python3.9/site-packages/pgactivity/ui.py
/usr/lib/python3.9/site-packages/pgactivity/utils.py
/usr/lib/python3.9/site-packages/pgactivity/views.py
/usr/lib/python3.9/site-packages/pgactivity/widgets.py
/usr/share/doc/pg_activity
/usr/share/doc/pg_activity/AUTHORS.md
/usr/share/doc/pg_activity/README.md
/usr/share/licenses/pg_activity
/usr/share/licenses/pg_activity/LICENSE.txt
References
Summary
In this tutorial we learn how to install pg_activity on Fedora 34 using yum and dnf.