New server deploy fails. GPG check on PGDG Repo for PSQL 16

Bug reports
1

Since ApisCP defaults to install PSQL 15 and PSQL 15 has been causing issues, I opted to install PSQL 16 during bootstrap. During install, there is a failure. Doing a manual yum install of the package has the same result.

libpq5-17.0-42PGDG.rhel8.x86_64 fails a GPG verification

2024-09-25 21:49:50,647 p=5127 u=root n=dnf.[fork.6132] | Using rpmkeys executable at /bin/rpmkeys to verify signatures
2024-09-25 21:49:51,270 p=5121 u=root n=ansible | fatal: [localhost]: FAILED! => {"attempts": 2, "changed": false, "msg": "Failed to validate GPG signature for libpq5-17.0-42PGDG.rhel8.x86_64"}
2024-09-25 21:49:51,275 p=5121 u=root n=ansible | PLAY RECAP *********************************************************************
2024-09-25 21:49:51,275 p=5121 u=root n=ansible | localhost                  : ok=116  changed=0    unreachable=0    failed=1    skipped=80   rescued=0    ignored=0
2

I don’t need a fix, I already worked around it. Just reporting this in case it’s something you want to fix.

3

I suspect you might’ve had a bad mirror since that dependency went up Sept 24 but signature went up Sept 26 3:00 UTC:

Signature   : RSA/SHA256, Thu 26 Sep 2024 03:00:45 AM UTC, Key ID 40bca2b408b40d20

It wouldn’t be the first (nor second) time there’s been issues with the PostgreSQL repository.