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

Dear Devrim Gündüz,

you have been right.
The mistake has been in our SUSE Manager Environment.

This BUG ID can be closed
Many thanks for your quick response
and sorry for our misunderstanding

Kind regards
Heiko Kämpf

-----Ursprüngliche Nachricht-----
Von: Kämpf, Heiko (OWL-IT) <h(dot)kaempf2(at)owl-it(dot)de>
Gesendet: Donnerstag, 7. Januar 2021 08:10
An: Devrim Gündüz <devrim(at)gunduz(dot)org>; Kämpf, Heiko (OWL-IT) <h(dot)kaempf(at)owl-it(dot)de>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Betreff: 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