Description of problem: As of version 2.0-0-1 there was an update to fix compatibility with Postgresql 15. * Thu Jan 26 2023 Ondřej Sloup <osloup> - 2.0-0-1 - Rebase to the newest version - Fix compatibility with PostgreSQL 15 this package can not install with postgresql:15 as it requires a dependency from postgresql:13 (the non modular stream) Version-Release number of selected component (if applicable): pg_auto_failover-2.0-3.el9.x86_64 Steps to Reproduce: # yum module enable postgresql:15 -y # yum install pg_auto_failover --enablerepo=epel Actual results: Error: Problem: package pg_auto_failover-2.0-3.el9.x86_64 from epel requires libpq.so.private13-5()(64bit), but none of the providers can be installed - conflicting requests - package postgresql-private-libs-13.5-1.el9.x86_64 from rhel-9-for-x86_64-appstream-rpms is filtered out by modular filtering - package postgresql-private-libs-13.7-1.el9_0.x86_64 from rhel-9-for-x86_64-appstream-rpms is filtered out by modular filtering - package postgresql-private-libs-13.10-1.el9_1.x86_64 from rhel-9-for-x86_64-appstream-rpms is filtered out by modular filtering - package postgresql-private-libs-13.11-1.el9_2.x86_64 from rhel-9-for-x86_64-appstream-rpms is filtered out by modular filtering - package postgresql-private-libs-13.13-1.el9_3.x86_64 from rhel-9-for-x86_64-appstream-rpms is filtered out by modular filtering (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages) Expected results: Trying to confirm if this is an unintentional dependency bug, or if this is only meant for postgresql:13 for Red Hat. Additional info:
pg_auto_failover is intended to be installed only with the system version of postgresql. In this case, PG 13. This component is not part of any modular build. It needs a deeper investigation into whether it is possible to build it for the newer version (PG15) of postgresql and persist backward installability(PG13).
Package only supports the default version of PostgreSQL, which as of now is 16. Backwards compatibility is currently not possible.
Hi Ales Nezbeda Enabling postgresql version 16 yum module enable postgresql:16 yum search postgres does not show pg_auto_failover as available in EPEL9 So package is still only supporting postgresql version 13 and postgresql version 13 not available in EPEL9 anymore Regards Allan
"The goal of EPEL is to make high quality Fedora packages available for RHEL and compatible derivatives."[1] PostgreSQL 13 is the default version of Postgresql in RHEL9. So it's available. As was mentioned, this component is intended to be supported with just a single Postgresql version in EPEL. And AFAIK, it's PG 13. [1] https://docs.fedoraproject.org/en-US/epel/
Hi PG 13 and PG14 not available in Red Hat Enterprise Linux release 9.3 (Plow): [root@db-pgwitnesshe08c ~]# yum module enable postgresql:13 Updating Subscription Management repositories. Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 53 kB/s | 4.5 kB 00:00 Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 96 kB/s | 4.1 kB 00:00 EPEL9 31 kB/s | 2.3 kB 00:00 Error: Problems in request: missing groups or modules: postgresql:13 [root@db-pgwitnesshe08c ~]# yum module enable postgresql:14 Updating Subscription Management repositories. Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 100 kB/s | 4.5 kB 00:00 Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 74 kB/s | 4.1 kB 00:00 EPEL9 87 kB/s | 2.3 kB 00:00 Error: Problems in request: missing groups or modules: postgresql:14 PG15 or PG16 can be enabled: [root@db-pgwitnesshe08c ~]# yum module enable postgresql:15 Updating Subscription Management repositories. Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 106 kB/s | 4.5 kB 00:00 Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 93 kB/s | 4.1 kB 00:00 EPEL9 68 kB/s | 2.3 kB 00:00 Dependencies resolved. ================================================================================================================================================================================================= Package Architecture Version Repository Size ================================================================================================================================================================================================= Enabling module streams: postgresql 15 Transaction Summary ================================================================================================================================================================================================= Is this ok [y/N]: n Operation aborted. [root@db-pgwitnesshe08c ~]# yum module enable postgresql:16 Updating Subscription Management repositories. Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 105 kB/s | 4.5 kB 00:00 Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 98 kB/s | 4.1 kB 00:00 EPEL9 66 kB/s | 2.3 kB 00:00 Dependencies resolved. ================================================================================================================================================================================================= Package Architecture Version Repository Size ================================================================================================================================================================================================= Enabling module streams: postgresql 16 Transaction Summary ================================================================================================================================================================================================= Is this ok [y/N]: n Operation aborted. So in my oppinion pg_auto_failover should work with PG15 or PG16. Regards Allan
It is available. Just type dnf install postgresql. And do not enable any module. It's not the modular content in RHEL9.