postgresql16-contrib-16.11-1PGDG.rhel9.x86_64 fails to install on Rocky9 due to OPENSSSL version mismatch (not available)

Doing my regular OS updates tonight, I encountered the following on all of my postgresql-16 servers:

Error:
Problem 1: cannot install the best update candidate for package postgresql16-contrib-16.10-1PGDG.rhel9.x86_64
- nothing provides libcrypto.so.3(OPENSSL_3.4.0)(64bit) needed by postgresql16-contrib-16.11-1PGDG.rhel9.x86_64 from pgdg16
Problem 2: problem with installed package postgresql16-contrib-16.10-1PGDG.rhel9.x86_64
- package postgresql16-contrib-16.10-1PGDG.rhel9.x86_64 from @System requires postgresql16(x86-64) = 16.10-1PGDG.rhel9, but none of the providers can be installed
- package postgresql16-contrib-16.10-1PGDG.rhel9.x86_64 from pgdg16 requires postgresql16(x86-64) = 16.10-1PGDG.rhel9, but none of the providers can be installed
- cannot install both postgresql16-16.11-1PGDG.rhel9.x86_64 from pgdg16 and postgresql16-16.10-1PGDG.rhel9.x86_64 from @System
- cannot install both postgresql16-16.11-1PGDG.rhel9.x86_64 from pgdg16 and postgresql16-16.10-1PGDG.rhel9.x86_64 from pgdg16
- cannot install the best update candidate for package postgresql16-16.10-1PGDG.rhel9.x86_64
- nothing provides libcrypto.so.3(OPENSSL_3.4.0)(64bit) needed by postgresql16-contrib-16.11-1PGDG.rhel9.x86_64 from pgdg16
(try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

My hosts use postgres from the popular pgdg repositories.

My best guess is the systems that build the pgdg rpms (in this case, the rpm for "postgresql16-contrib") are built against are now "too new" in terms of OPENSSL. Perhaps that environment is using Centos Stream?

Anyway, back to my report. Rocky 9 does not HAVE "libcrypto.so.3(OPENSSL_3.4.0)". It's... too new.

My updated Rocky9 hosts currently have OPENSSL 3.2.2. That is I believe the latest available in Rocky 9's libcrypto.

While I cannot determine this at this moment, I suspect this will affect anyone using RHEL 9, Rocky 9, and Almalinux 9. POSSIBLY Oracle Linux 9 too.

I am available to do any further testing or provide any other information you require.

Thank you.

-Kent Brodie
Systems Administrator
Medical College of Wisconsin