Error: Problem: cannot install the best update candidate for package pg_activity-2.3.1-1.rhel8.noarch

Hello, trying to update pg_activity, but getting below errors.

dnf update pg_activity.noarch
Last metadata expiration check: 0:01:17 ago on Thu 16 Mar 2023 02:04:38 PM +03.
Error:
 Problem: cannot install the best update candidate for package pg_activity-2.3.1-1.rhel8.noarch
  - nothing provides python3-attrs >= 18.1 needed by pg_activity-3.1.1-1.rhel8.noarch
  - nothing provides python3-humanize >= 2.6.0 needed by pg_activity-3.1.1-1.rhel8.noarch
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

version
NAME=“Rocky Linux”
VERSION=“8.7 (Green Obsidian)”
ID=“rocky”
ID_LIKE=“rhel centos fedora”
VERSION_ID=“8.7”
PLATFORM_ID=“platform:el8”
PRETTY_NAME=“Rocky Linux 8.7 (Green Obsidian)”
ANSI_COLOR=“0;32”
LOGO=“fedora-logo-icon”
CPE_NAME=“cpe:/o:rocky:rocky:8:GA”
HOME_URL=“https://rockylinux.org/”
BUG_REPORT_URL=“https://bugs.rockylinux.org/”
ROCKY_SUPPORT_PRODUCT=“Rocky-Linux-8”
ROCKY_SUPPORT_PRODUCT_VERSION=“8.7”
REDHAT_SUPPORT_PRODUCT=“Rocky Linux”
REDHAT_SUPPORT_PRODUCT_VERSION=“8.7”

Package python3-attrs-17.4.0-6.el8.noarch is already installed.
Package python3-humanize-0.5.1-13.el8.noarch is already installed.
 dnf check-update python3-attrs.noarch python3-humanize.noarch
Last metadata expiration check: 0:00:25 ago on Thu 16 Mar 2023 02:11:18 PM +03.

Where do those come from?

Comes from postgres repositories according to pkgs.org: https://pkgs.org/search/?q=pg_activity

So problem is not Rocky, but Postgres repo’s. Perhaps install postgres that comes with Rocky/RHEL.

dnf module list postgresql
Last metadata expiration check: 3:58:25 ago on Thu 16 Mar 2023 09:48:36 AM CET.
Rocky Linux 8 - AppStream
Name                Stream          Profiles                    Summary                                    
postgresql          9.6             client, server [d]          PostgreSQL server and client module        
postgresql          10 [d]          client, server [d]          PostgreSQL server and client module        
postgresql          12 [e]          client, server [d]          PostgreSQL server and client module        
postgresql          13              client, server [d]          PostgreSQL server and client module        

Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled

even postgres 13 can be installed on Rocky8 without having to resort to using postgres’s repositories. Or perhaps what you are trying to achieve and why you use the external postgres repo, and for what is pg_activity required?

I’m using external repo because I need extra packages and extentions for postgres.
pg_activity is also a monitoring tool for postgres.

pgdg-common PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64

You have to ask from the maintainers of that repository why they have built
the pg_activity-3.1.1-1.rhel8.noarch to depend on package versions that
apparently are not in RHEL8.