pg_activity icon indicating copy to clipboard operation
pg_activity copied to clipboard
verified publisher icon dalibo

Help for installation pg_activity 3.0.1

Open egaultier opened this issue 3 years ago • 2 comments

Hi

I want install pg_activity 3.0.1 on RheL 8.6

I have this error : image

I install python39 with yum command sudo yum install python39

image

I have the same error when I want to install yet pg_activity 3.0.1

Thx for your help.

Emmanuel

egaultier avatar Sep 30 '22 13:09 egaultier

Hi,

Thanks for the report. There is a packaging problem on Redhat 8 (see https://github.com/dalibo/pg_activity/issues/319 and redmine)

blogh avatar Oct 03 '22 08:10 blogh

The install with pip works (I you have the required access)

blogh avatar Oct 03 '22 11:10 blogh

I have similar error on Rocky 9

Last metadata expiration check: 0:24:52 ago on Thu 10 Nov 2022 05:07:34 PM +03. Error: Problem: cannot install the best candidate for the job

  • nothing provides python3.9dist(blessed) needed by pg_activity-3.0.0-1.rhel9.noarch
  • nothing provides python3-blessed needed by pg_activity-3.0.0-1.rhel9.noarch
  • nothing provides python3-humanize >= 2.6.0 needed by pg_activity-3.0.0-1.rhel9.noarch
  • nothing provides python3.9dist(humanize) >= 2.6 needed by pg_activity-3.0.0-1.rhel9.noarch (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

bagafoot avatar Nov 10 '22 14:11 bagafoot

@bagafoot if release 2.3.1 is enough for you, it should be available in EPEL9 next week. You can test the build with this update https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2022-89a5b2ec98

mikelolasagasti avatar Dec 17 '22 11:12 mikelolasagasti

pg_activity 3.x.x is giving errors on Almalinux as well. I think it was not the best to publish such package to PGDG that requires dependencies that will not be provided so soon to AppStream RPM repository:

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

Probably alternative would be to provide also required python packages in PGDG-common.

krisavi avatar Mar 14 '23 10:03 krisavi

nothing provides python3-attrs >=18.1 needed by pg_activity-3.1.1-1.rhel8.noarch

This one is a packaging bug, we have no such lower bound on our side.

nothing provides python3-humanize >= 2.6.0 needed by pg_activity-3.1.1-1.rhel8.noarch

This is being worked around in #345.

In any case, EPEL would probably be required.

dlax avatar Mar 14 '23 10:03 dlax

EPEL is not enough on RHEL8. On RHEL8 I doubt new versions will be pushed to EPEL. Not such big change in versions.

In order to avoid a lot of users getting issues with DNF upgrade process, 3.x.x branch packages could be pulled from el8 PGDG repo, just like it was done 6 months ago.

python3-humanize is not available in EPEL for EL8, so EPEL would not make a difference here. Latest package available in AppStream is python3-humanize-0.5.1-13.el8.noarch.rpm For python3-attrs, the same thing, not available in EPEL, and latest available in AppStream is python3-attrs-17.4.0-6.el8.noarch.rpm

EPEL is used to provide python3-wcwidth and python3-blessed and I do not have errors about those packages.

In a nutshell pg_activity-3.1.1-1.rhel8.noarch have dependency requirements that cannot be solved for EL8 using EPEL, PGDG and distribution official repositories, may it be RHEL8, OL8, AlmaLinux8, RockyLinux8 or similar. If it is just packaging issue, then the dependencies have to be defined by someone and could be changed. I would guess to be linked to https://github.com/dalibo/pg_activity/blob/master/setup.py#L46-L51.

However if those are really the requirements, then I see 2 solutions, either pull that version or provide required python packages as alternative. Pulling that version will avoid it giving errors on dnf update or dnf install pg_activity as it will install older version that still works. Providing required python3 packages should make it possible to install pg_activity-3.1.1 (and probably newer ones) on EL8.

krisavi avatar Mar 14 '23 11:03 krisavi

Latest package available in AppStream is python3-humanize-0.5.1-13.el8.noarch.rpm

With which we'll restore compatibility from #354.

For python3-attrs, the same thing, not available in EPEL, and latest available in AppStream is python3-attrs-17.4.0-6.el8.noarch.rpm

With which we already are compatible; but for which there is a buggy constraint in PGDG packaging as reported here.

Sorry; I apparently confused_ appstream and EPEL. But in any case, I think this can be sorted out.

dlax avatar Mar 14 '23 12:03 dlax

I think we have done everything we can on our side, by relaxing dependencies to help packaging work. Though there are still work to be done on packaging side, this is tracked over https://redmine.postgresql.org/projects/pgrpms/.

In the meantime, I'd suggest that people install through pip.

dlax avatar Mar 28 '23 07:03 dlax

In the meantime, I'd suggest that people install through pip.

I tried install through pip but pip installing 2.3.1 too for now. we should wait, nottihng to do right now I think

bagafoot avatar Mar 28 '23 09:03 bagafoot

I tried install through pip but pip installing 2.3.1 too for now.

Which Python version are you using? If you want a recent version of pg_activity, you need at least Python 3.7.

dlax avatar Mar 28 '23 09:03 dlax

I tried install through pip but pip installing 2.3.1 too for now.

Which Python version are you using? If you want a recent version of pg_activity, you need at least Python 3.7.

hmm, I got Python 3.6, ok thanks

bagafoot avatar Apr 05 '23 06:04 bagafoot