RE: PostgreSQL Yum Repository - Mailing list pgsql-pkg-yum

From Hanefi Onaldi
Subject RE: PostgreSQL Yum Repository
Date
Msg-id LV2PR21MB3183480DA0CE37D32ADC540EE3119@LV2PR21MB3183.namprd21.prod.outlook.com
Whole thread Raw
Responses RE: PostgreSQL Yum Repository
List pgsql-pkg-yum
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.
 
 
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://www.redhat.com/sysadmin/rpm-gpg-verify-packages
 
Best,
Hanefi
_____________________________________________
From: Jones, Anthony D CIV USN FLTREADCEN ECP NC (USA) <anthony.d.jones3.civ@us.navy.mil>
Sent: 15 Mart 2022 Salı 16:58
To: pgsql-pkg-yum@postgresql.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.
 
 
 

pgsql-pkg-yum by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Bad GPG signature error while trying to install on arm64
Next
From: "Jones, Anthony D CIV USN FLTREADCEN ECP NC (USA)"
Date:
Subject: RE: PostgreSQL Yum Repository