Bug 2258066

Summary: pg_auto_failover requires postgresql:13 and fails to install with postgresql:15
Product: [Fedora] Fedora EPEL Reporter: jcastran
Component: pg_auto_failoverAssignee: Filip Januš <fjanus>
Status: CLOSED NOTABUG QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: epel9CC: allan.h.nielsen, anezbeda, fjanus, hhorak, osloup
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2024-05-30 11:34:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description jcastran 2024-01-12 14:37:10 UTC
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:

Comment 1 Filip Januš 2024-01-18 08:39:47 UTC
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).

Comment 3 Ales Nezbeda 2024-05-30 11:34:01 UTC
Package only supports the default version of PostgreSQL, which as of now is 16.

Backwards compatibility is currently not possible.

Comment 4 Allan Harry Nielsen 2024-06-06 16:11:08 UTC
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

Comment 5 Filip Januš 2024-06-10 07:59:32 UTC
"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/

Comment 6 Allan Harry Nielsen 2024-06-12 20:22:24 UTC
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

Comment 7 Filip Januš 2024-06-12 20:27:12 UTC
It is available. Just type dnf install postgresql. And do not enable any module. It's not the modular content in RHEL9.