postgresql11-11.14-1PGDG.rhel8.x86_64.rpm reports incorrect name

From: "Miller, Mark - Xylem" <MarkD(dot)Miller(at)xylem(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: postgresql11-11.14-1PGDG.rhel8.x86_64.rpm reports incorrect name
Date: 2022-05-02 13:55:04
Message-ID: SN6PR01MB45736F18B983F3B1C6C01D249CC19@SN6PR01MB4573.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

We were having trouble installing postgres 11.14 on RedHat EL8, we placed all the postgres 11.14 RHEL 8 RPMs in a local repo, but when we listed what was available from the repo it did not show the postgres11.x86_64 as being available though it did show postgresq11-contrib.x64_64, postgresq11-libs.x64_64, postgresq11-server.x64_64.

Here is the output of the yum list available:
yum --disablerepo="*" --enablerepo="Sensus_Repository" list available
it has the following rpms starting with post:
postgis25_11.x86_64 2.5.5-4.rhel8 Sensus_Repository
postgresql11-contrib.x86_64 11.14-1PGDG.rhel8 Sensus_Repository
postgresql11-libs.x86_64 11.14-1PGDG.rhel8 Sensus_Repository
postgresql11-server.x86_64 11.14-1PGDG.rhel8 Sensus_Repository
postinstalltool.noarch 0.0.0072-362956 Sensus_Repository

While the repo directory has:
[root(at)metis72f-chef ~]# ls -al /var/ftp/sensus-iso/linux/thirdparty/postgresql
total 19656
drwxrwxr-x. 3 ftpuser ftpuser 4096 Apr 29 14:34 .
drwxrwxr-x. 4 ftpuser ftpuser 36 Apr 29 14:34 ..
-rw-rw-r--. 1 ftpuser ftpuser 7824712 Apr 29 14:34 gdal-libs-3.0.4-10.el8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 663684 Apr 29 14:34 geos38-3.8.1-2.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 101052 Apr 29 14:34 libgeotiff-1.5.1-1.el8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 4666904 Apr 29 14:34 postgis25_11-2.5.5-4.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 403220 Apr 29 14:34 postgresql11-11.14-1PGDG.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 658828 Apr 29 14:34 postgresql11-contrib-11.14-1PGDG.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 403220 Apr 29 14:34 postgresql11-libs-11.14-1PGDG.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 5139304 Apr 29 14:34 postgresql11-server-11.14-1PGDG.rhel8.x86_64.rpm
-rw-rw-r--. 1 ftpuser ftpuser 220740 Apr 29 14:34 proj49-4.9.3-3.rhel7.1.x86_64.rpm
drwxrwxr-x. 2 ftpuser ftpuser 4096 Apr 29 14:34 repodata
-rw-rw-r--. 1 ftpuser ftpuser 19488 Apr 29 14:34 SFCGAL-1.3.7-2.rhel8.x86_64.rpm

I think the problem is that the postgresql11-11.14-1PGDG.rhel8.x86_64.rpm reports the name postgresql11-libs instead of postgresql11:

[root(at)metis72f-chef linux]# rpm -qi ./thirdparty/postgresql/postgresql11-11.14-1PGDG.rhel8.x86_64.rpm

warning: ./thirdparty/postgresql/postgresql11-11.14-1PGDG.rhel8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY

Name : postgresql11-libs

Version : 11.14

Release : 1PGDG.rhel8

Architecture: x86_64

Install Date: (not installed)

Group : Unspecified

Size : 1507171

License : PostgreSQL

Signature : DSA/SHA1, Thu 11 Nov 2021 04:24:46 AM EST, Key ID 1f16d2e1442df0f8

Source RPM : postgresql11-11.14-1PGDG.rhel8.src.rpm

Build Date : Thu 11 Nov 2021 01:40:38 AM EST

Build Host : koji-rhel8-x86-64-pgbuild

Relocations : (not relocatable)

Vendor : PostgreSQL Global Development Group

URL : https://www.postgresql.org/

Summary : The shared libraries required for any PostgreSQL clients

Description :

The postgresql11-libs package provides the essential shared libraries for any

PostgreSQL client program or interface. You will need to install this package

to use any other PostgreSQL package or any clients that need to connect to a

PostgreSQL server.

Note; the RHEL 7 rpm is named postgresql11:
[root(at)self104-chef ~]# rpm -qip /var/ftp/sensus-iso/linux/thirdparty/postgresql/postgresql11-11.14-1PGDG.rhel7.x86_64.rpm
warning: /var/ftp/sensus-iso/linux/thirdparty/postgresql/postgresql11-11.14-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Name : postgresql11
Version : 11.14
Release : 1PGDG.rhel7
Architecture: x86_64
Install Date: (not installed)
Group : Unspecified
Size : 9256842
License : PostgreSQL
Signature : DSA/SHA1, Thu 11 Nov 2021 04:24:47 AM EST, Key ID 1f16d2e1442df0f8
Source RPM : postgresql11-11.14-1PGDG.rhel7.src.rpm
Build Date : Wed 10 Nov 2021 11:15:20 AM EST
Build Host : koji-centos7-x86-64-pgbuild
Relocations : (not relocatable)
Vendor : PostgreSQL Global Development Group
URL : https://www.postgresql.org/
Summary : PostgreSQL client programs and libraries
Description :
PostgreSQL is an advanced Object-Relational database management system (DBMS).
The base postgresql package contains the client programs that you'll need to
access a PostgreSQL DBMS server, as well as HTML documentation for the whole
system. These client programs can be located on the same machine as the
PostgreSQL server, or on a remote machine that accesses a PostgreSQL server
over a network connection. The PostgreSQL server can be found in the
postgresql11-server sub-package.

If you want to manipulate a PostgreSQL database on a local or remote PostgreSQL
server, you need this package. You also need to install this package
if you're installing the postgresql11-server package.

Thanks,
Mark

Mark Miller (he, him, his)
Tech lead Software Engineer
Xylem
639 Davis Drive
Morrisville, NC 27560
O: +1.919.317.6154 M: +1.919.389.9452
[Xylem_tag_email_120px]

[cid:image003(dot)jpg(at)01D85E0A(dot)AF271E50]

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Van Droogenbroeck David 2022-05-03 08:17:28 bug in postgres 14.2
Previous Message LEMAIRE Leslie - SG/SNUM/UNI/DRC (Chargée de mission) 2022-05-02 11:27:20 Implicitly created operator family not listed by pg_event_trigger_ddl_commands