RE: PostgreSQL Yum Repository

Thank you.. I am good now. RedHat replied with this info should you all need it provided the user has RedHat subscriptions.

While RHEL7 only supports the "postgresql 9.2.24" package during its lifecycle, there is an alternative if you use the (RHCSL) Red Hat Software Collection version of this package. This version will allow you to enter an environment/subshell that will allow you to run postgresql10+. You will need to first enable the software collection prehistory and then install the package.

# subscription-manager repos --enable=rhel-server-rhscl-7-rpms
# yum install rh-postgresql10
# scl enable rh-postgresql10 bash
# exit <-------exit postgresql10 environment

Thank you,

Tony Jones – Teleworking
Security+ ce, Server+
Asset Management / IBMEST
FRCE Cherry Point
☎OFF: 252.464.7253
📱CELL: 252.626.8288
DM: TEAMS/Skype

From: Hanefi Onaldi <Hanefi(dot)Onaldi(at)microsoft(dot)com>
Sent: Wednesday, March 16, 2022 5:04 PM
To: Jones, Anthony D CIV USN FLTREADCEN ECP NC (USA) <anthony(dot)d(dot)jones3(dot)civ(at)us(dot)navy(dot)mil>; pgsql-pkg-yum(at)postgresql(dot)org
Subject: [URL Verdict: Neutral][Non-DoD Source] RE: PostgreSQL Yum Repository

Hi Anthony,

I am no yum repo expert, but I have a guess that could work.

Similar to how you downloaded the rpm for the packages, you can also install the GPG public key for the repository.

You can download the key from <https://usg01.safelinks.protection.office365.us/?url=https%3A%2F%2Fdownload.postgresql.org%2Fpub%2Frepos%2Fyum%2FRPM-GPG-KEY-PGDG&data=04%7C01%7Canthony.d.jones3.civ%40us.navy.mil%7C1e07ee06fe424f7d179908da07907f34%7Ce3333e00c8774b87b6ad45e942de1750%7C0%7C0%7C637830615759530259%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=KSbNsZSmUxTL%2BOtE0w2DaiiR%2F2zhrPKLZG0Gfi5YUO4%3D&reserved=0> https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG

Then you can run “rpm –import RPM-GPG-KEY-PGDG” to import the public key. Alternatively, you can supply “gpgkey=file:///path/to/ RPM-GPG-KEY-PGDG” manually.

I think that either way you choose, you should reset gpgcheck to 1 to make use of the public key to verify the packages that are installed from this repo.

You can read through the redhat docs for more info here: <https://usg01.safelinks.protection.office365.us/?url=https%3A%2F%2Fwww.redhat.com%2Fsysadmin%2Frpm-gpg-verify-packages&data=04%7C01%7Canthony.d.jones3.civ%40us.navy.mil%7C1e07ee06fe424f7d179908da07907f34%7Ce3333e00c8774b87b6ad45e942de1750%7C0%7C0%7C637830615759530259%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=Z8oYxMf0AYKWzjWkclougrKQohizzABz9xJA9bAKGGs%3D&reserved=0> https://www.redhat.com/sysadmin/rpm-gpg-verify-packages

Best,
Hanefi
_____________________________________________
From: Jones, Anthony D CIV USN FLTREADCEN ECP NC (USA) <anthony(dot)d(dot)jones3(dot)civ(at)us(dot)navy(dot)mil>
Sent: 15 Mart 2022 Salı 16:58
To: pgsql-pkg-yum(at)postgresql(dot)org
Subject: [EXTERNAL] PostgreSQL Yum Repository


I cannot get the repo installed. This is going to cause our ATO to not be approved if I cannot get upgraded. Currently on PostgreSQL 9.2.24.
I had to download to my workstation to RHeL 7x /tmp folder, then set the yum.conf gpgcheck=1 to 0 to get this far. So, it’s not installed yet.

yum install -y /tmp/pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
Examining /tmp/pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-24.noarch
Marking /tmp/pgdg-redhat-repo-latest.noarch.rpm as an update to pgdg-redhat-repo-42.0-14.noarch
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-14 will be updated
---> Package pgdg-redhat-repo.noarch 0:42.0-24 will be an update
--> Finished Dependency Resolution
--> Finding unneeded leftover dependencies
Found and removing 0 unneeded dependencies

Dependencies Resolved

========================================================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================================================
Updating:
pgdg-redhat-repo noarch 42.0-24 /pgdg-redhat-repo-latest.noarch 12 k

Transaction Summary
========================================================================================================================================================================================================
Upgrade 1 Package

Total size: 12 k
Downloading packages:
warning: /tmp/pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY

Public key for pgdg-redhat-repo-latest.noarch.rpm is not installed

Thank you,

Tony Jones - Teleworking
Asset Management / IBMEST
FRCE Cherry Point
Hours: M-F 0600-1430
☎ OFF: 252.464.7253
☎ DSN: 451.7253
📱 CELL: 252.626.8288
DM: TEAMS
<< OLE Object: Picture (Device Independent Bitmap) >> << OLE Object: Picture (Device Independent Bitmap) >>
“One who fears failure limits his activities. Failure is only the opportunity to more intelligently begin again. “ Henry Ford.
“Greatest thing in life is experience. Even Mistakes have Value.” Henry Ford

To tell us what you think about the Command Operations Department products/services/personnel, cut and paste this link into your browser.
<https://usg01.safelinks.protection.office365.us/?url=https%3A%2F%2Fmyteam.navair.navy.mil%2Fcorpapps%2Fsurveytool%2FLists%2FCommand_Ops_Customer_Service_Feedback%2FNewForm.aspx&data=04%7C01%7Canthony.d.jones3.civ%40us.navy.mil%7C1e07ee06fe424f7d179908da07907f34%7Ce3333e00c8774b87b6ad45e942de1750%7C0%7C0%7C637830615759530259%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=sIy%2BJdLOSKx%2BPgUiNWKBZPK5dzajr8jwatvJNQTKFK4%3D&reserved=0> https://myteam.navair.navy.mil/corpapps/surveytool/Lists/Command_Ops_Customer_Service_Feedback/NewForm.aspx