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

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@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@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@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