[ansible/artifactory] operational issue: PostgreSQL GPG key URL changed

[bbaassssiiee]

Is this a request for help?:

---

Is this a BUG REPORT or FEATURE REQUEST? (choose one):
BUG REPORT

Which installer:
ansible

Which product and version (eg: ansible & collection version - 7.24.2):

Which operating system and version(eg: ubuntu & version - 20.4):
rhel8

Which product license (Enterprise/Pro):
All

JFrog support reference (if already raised with support team):

What happened:

The filename and directory for the GPG repo key of postgresql change 2024-01-03 causing the installer to break!

There is no way to override this due to hard-coding:

JFrog-Cloud-Installers/Ansible/ansible_collections/jfrog/platform/roles/postgres/tasks/RedHat.yml

Line 40 in c5ff527

key: https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG

What you expected to happen:
Another install

How to reproduce it (as minimally and precisely as possible):
Install it with any previous version of this collection.

Anything else we need to know:

Please create a default postgres_rpmkey_url: "https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL"

[bbaassssiiee]

A daily CI build helps detect such failures.

[bbaassssiiee]

When we look at the same URL as yesterday we can explain another issue, PostgreSQL 11 is EOL.

PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                      1.3 kB/s | 659  B     00:00
PostgreSQL 16 for RHEL / Rocky 8 - x86_64                                               4.1 kB/s | 659  B     00:00
PostgreSQL 15 for RHEL / Rocky 8 - x86_64                                               8.2 kB/s | 659  B     00:00
PostgreSQL 14 for RHEL / Rocky 8 - x86_64                                               1.3 kB/s | 659  B     00:00
PostgreSQL 13 for RHEL / Rocky 8 - x86_64                                               4.5 kB/s | 659  B     00:00
PostgreSQL 12 for RHEL / Rocky 8 - x86_64                                               3.1 kB/s | 659  B     00:00
PostgreSQL 11 for RHEL / Rocky 8 - x86_64                                               791  B/s | 146  B     00:00
Errors during downloading metadata for repository 'pgdg11':
  - Status code: 404 for https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-8-x86_64/repodata/repomd.xml (IP: 217.196.149.55)
Error: Failed to download metadata for repo 'pgdg11': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried