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@gunduz.org> 
Gesendet: Mittwoch, 6. Januar 2021 18:53
An: Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.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.kaempf@owl-it.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-providedpackages?
 

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