Error Installation to Rockylinux 9 - Solved

[prakasa1904]

I got error below when try to install to ROckyLinux 9, need some clue since I'am new in RHEL, thanks!

(dpanel-iac-ansible) ── TASK [ANXS.postgresql : PostgreSQL | Install PostgreSQL | RHEL] ****************
(dpanel-iac-ansible) ── fatal: [ansible-inventory-rockylinux-9]: FAILED! => {"changed": false, "msg": "Failed to validate GPG signature for postgresql17-17.9-1PGDG.rhel9.7.aarch64: Public key for postgresql17-17.9-1PGDG.rhel9.7.aarch64.rpm is not installed"}

Variable I used:

{
  "postgresql_listen_addresses": [
    "*"
  ],
  "postgresql_version": 17
}

I try to install manually, and I found detail errors below:

GPG key at https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL (0x08B40D20) is already installed
The GPG keys listed for the "postgresql yum repo" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.. Failing package is: postgresql17-17.9-1PGDG.rhel9.7.aarch64
 GPG Keys are configured as: https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL
Public key for postgresql17-libs-17.9-1PGDG.rhel9.7.aarch64.rpm is not installed. Failing package is: postgresql17-libs-17.9-1PGDG.rhel9.7.aarch64
 GPG Keys are configured as: https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL
Public key for postgresql17-server-17.9-1PGDG.rhel9.7.aarch64.rpm is not installed. Failing package is: postgresql17-server-17.9-1PGDG.rhel9.7.aarch64
 GPG Keys are configured as: https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'dnf clean packages'.
Error: GPG check FAILED
[root@8574564f60e5 yum.repos.d]# ls
epel-cisco-openh264.repo  epel-testing.repo  rocky-addons.repo	rocky-extras.repo
epel.repo		  postgresql.repo    rocky-devel.repo	rocky.repo
[root@8574564f60e5 yum.repos.d]# cat postgresql.repo
[postgresql]
baseurl = http://yum.postgresql.org/17/redhat/rhel-9-aarch64
enabled = 1
gpgkey = https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL
name = postgresql yum repo

What I highlight is, seems like pkg postgresql17-server-17.9-1PGDG.rhel9.7.aarch64 doesn't exist. And when I try to check from:
https://download.postgresql.org/pub/repos/yum/17/redhat/rhel-9-aarch64/

I found postgresql17-server-17.9-1PGDG.rhel9.7.aarch64.rpm exist.. What I miss ?

[prakasa1904]

I follow official document https://www.postgresql.org/download/linux/redhat/ and it works now. PR coming soon!