AW: BUG #16806: postgresql10 rpm is installed in the wrong directory

Dear Devrim Gündüz,

it seems, you are right, the current installed version the package is from SUSE:

# rpm -qi postgresql10-server-10.15-4.9.1.x86_64
Name : postgresql10-server
Version : 10.15
Release : 4.9.1
Architecture: x86_64
Install Date: Wed Dec 16 10:12:24 2020
Group : Productivity/Databases/Servers
Size : 19253470
License : PostgreSQL
Signature : RSA/SHA256, Tue Nov 17 13:46:01 2020, Key ID 70af9e8139db7c82
Source RPM : postgresql10-10.15-4.9.1.src.rpm
Build Date : Tue Nov 17 13:42:43 2020
Build Host : sheep22
Relocations : (not relocatable)
Packager : https://www.suse.com/
Vendor : SUSE LLC <https://www.suse.com/>
URL : https://www.postgresql.org/
Summary : The Programs Needed to Create and Run a PostgreSQL Server
Description :
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, sub-queries, triggers, and user-defined
types and functions.

This package includes the programs needed to create and run a
PostgreSQL server, which will in turn allow you to create and maintain
PostgreSQL databases.
Distribution: SUSE Linux Enterprise 12

Before it has bee from PostgreSQL

lipgsqlgisp1:~ # rpm -qi postgresql10-10.14-1PGDG.sles12.x86_64
Name : postgresql10
Version : 10.14
Release : 1PGDG.sles12
Architecture: x86_64
Install Date: Fri Sep 4 12:54:14 2020
Group : Unspecified
Size : 15161078
License : PostgreSQL
Signature : DSA/SHA1, Thu Aug 13 16:06:28 2020, Key ID 1f16d2e1442df0f8
Source RPM : postgresql10-10.14-1PGDG.sles12.src.rpm
Build Date : Thu Aug 13 16:05:36 2020
Build Host : host-192-168-16-145
Relocations : (not relocatable)
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
postgresql10-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 postgresql10-server package.
Distribution: (none)

So we have to check our SUSE Manager environment what's wrong there.
I will keep you informed about our result.

Kind regards
Heiko Kämpf

-----Ursprüngliche Nachricht-----
Von: Devrim Gündüz <devrim(at)gunduz(dot)org>
Gesendet: Mittwoch, 6. Januar 2021 18:53
An: Kämpf, Heiko (OWL-IT) <h(dot)kaempf(at)owl-it(dot)de>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Betreff: Re: BUG #16806: postgresql10 rpm is installed in the wrong directory

Hi,

On Tue, 2021-01-05 at 14:47 +0000, PG Bug reporting form wrote:
>
> Bug reference:      16806
> Logged by:          heiko kaempf
> Email address:      h(dot)kaempf(at)owl-it(dot)de PostgreSQL version: 10.15
> Operating system:   SUSE Linux Enterprise Server 12 SP5
> Description:
>
> Dear PostgreSQL developer team,
>
> when installing postgreSQL10.15 and postgis30_10 for SLES12 SP5 from
> the following download repository:
> https://download.postgresql.org/pub/repos/zypp/12/suse/sles-12.5-x86_6
> 4/ The postgresql packages are installed in the directory path
> /usr/lib/postgresql10
> while the postGIS packages are using /usr/pgsql-10 as installation
> directory.
> As a result we have an inconsistent environment.

I think you are not installing PostgreSQL RPMs from our repo. We don't use /usr/lib directory. Maybe you are installing OS-provided packages?

Ours are: postgresql10-server, etc.

Can I please get an output of: rpm -qa | grep -i postgres

Thanks!

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR