BUG #18235: Unable to install postgreSQL15 on Oracle Cloud VM

The following bug has been logged on the website:

Bug reference: 18235
Logged by: Basavaraj Madiwalar
Email address: basavaraj(dot)madiwalar(at)finonyx(dot)com
PostgreSQL version: 15.0
Operating system: Oracle Linux 8
Description:

Dear Team,
Unable to install postgreSQL for testing purpose.

sudo dnf install -y
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Last metadata expiration check: 1:32:50 ago on Fri 08 Dec 2023 02:54:10 AM
GMT.
pgdg-redhat-repo-latest.noarch.rpm
25 kB/s | 13 kB 00:00
Dependencies resolved.
========================================================================================================================
Package Architecture Version
Repository Size
========================================================================================================================
Installing:
pgdg-redhat-repo noarch 42.0-35PGDG
@commandline 13 k

Transaction Summary
========================================================================================================================
Install 1 Package

Total size: 13 k
Installed size: 15 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing :
1/1
Installing : pgdg-redhat-repo-42.0-35PGDG.noarch
1/1
Verifying : pgdg-redhat-repo-42.0-35PGDG.noarch
1/1

Installed:
pgdg-redhat-repo-42.0-35PGDG.noarch

Complete!

dnf install postgresql15 postgresql15-server
PostgreSQL common RPMs for RHEL / Rocky 8 - aarch64
778 B/s | 833 B 00:01
PostgreSQL common RPMs for RHEL / Rocky 8 - aarch64
1.6 MB/s | 1.7 kB 00:00
PostgreSQL common RPMs for RHEL / Rocky 8 - aarch64
616 B/s | 833 B 00:01
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG
signature verification error: Bad GPG signature