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

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

From

PG Bug reporting form

Date:

05 January 2021, 14:47:55

The following bug has been logged on the website:

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_64/
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.

# cat /etc/os-release
NAME="SLES"
VERSION="12-SP5"
VERSION_ID="12.5"
PRETTY_NAME="SUSE Linux Enterprise Server 12 SP5"
ID="sles"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:suse:sles:12:sp5"

# rpm -qa|egrep 'postgresql10|postgis30_10'
postgis30_10-3.0.1-2.sles12.x86_64
postgis30_10-utils-3.0.1-2.sles12.x86_64
postgis30_10-client-3.0.1-2.sles12.x86_64
postgresql10-10.15-4.9.1.x86_64
postgresql10-server-10.15-4.9.1.x86_64
postgresql10-libs-10.15-1PGDG.sles12.x86_64
postgresql10-contrib-10.15-4.9.1.x86_64

# rpm -ql postgis30_10-3.0.1-2.sles12.x86_64|grep lib
/usr/pgsql-10/lib/address_standardizer-3.so
/usr/pgsql-10/lib/postgis-2.5.so
/usr/pgsql-10/lib/postgis-3.so
/usr/pgsql-10/lib/postgis_raster-2.5.so
/usr/pgsql-10/lib/postgis_raster-3.so
/usr/pgsql-10/lib/postgis_topology-2.5.so
/usr/pgsql-10/lib/postgis_topology-3.so

# rpm -ql postgresql10-10.15-4.9.1.x86_64|grep lib
/usr/lib/postgresql
/usr/lib/postgresql10/bin
/usr/lib/postgresql10/bin/clusterdb
/usr/lib/postgresql10/bin/createdb
/usr/lib/postgresql10/bin/createuser
/usr/lib/postgresql10/bin/dropdb
/usr/lib/postgresql10/bin/dropuser
/usr/lib/postgresql10/bin/pg_basebackup
/usr/lib/postgresql10/bin/pg_dump
/usr/lib/postgresql10/bin/pg_dumpall
/usr/lib/postgresql10/bin/pg_isready
/usr/lib/postgresql10/bin/pg_receivewal
/usr/lib/postgresql10/bin/pg_recvlogical
/usr/lib/postgresql10/bin/pg_restore
/usr/lib/postgresql10/bin/pg_rewind
/usr/lib/postgresql10/bin/psql
/usr/lib/postgresql10/bin/reindexdb
/usr/lib/postgresql10/bin/vacuumdb
/usr/lib/postgresql10/lib64

With the version 10.14 it was correct, it seams.
(output from a different server, also with SLES12 SP5)

# rpm -ql postgresql10-10.14-1PGDG.sles12.x86_64|grep lib
# rpm -ql postgresql10-10.14-1PGDG.sles12.x86_64|grep bin
/usr/pgsql-10/bin/clusterdb
/usr/pgsql-10/bin/createdb
/usr/pgsql-10/bin/createuser
/usr/pgsql-10/bin/dropdb
/usr/pgsql-10/bin/dropuser
/usr/pgsql-10/bin/pg_archivecleanup
/usr/pgsql-10/bin/pg_basebackup
/usr/pgsql-10/bin/pg_config
/usr/pgsql-10/bin/pg_dump
/usr/pgsql-10/bin/pg_dumpall
/usr/pgsql-10/bin/pg_isready
/usr/pgsql-10/bin/pg_receivewal
/usr/pgsql-10/bin/pg_restore
/usr/pgsql-10/bin/pg_rewind
/usr/pgsql-10/bin/pg_test_fsync
/usr/pgsql-10/bin/pg_test_timing
/usr/pgsql-10/bin/pg_upgrade
/usr/pgsql-10/bin/pg_waldump
/usr/pgsql-10/bin/pgbench
/usr/pgsql-10/bin/psql
/usr/pgsql-10/bin/reindexdb
/usr/pgsql-10/bin/vacuumdb
/usr/pgsql-10/share/man/man3/SPI_getbinval.3

Is there a chance to set any environment variable to overwrite the 
installation path when using zypper or rpm for the installation of
postgreSQL 10.15 packages?

Kind regards
Heiko Kämpf
OWL-IT Germany

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

From

Devrim Gündüz

Date:

06 January 2021, 17:53:20

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_64/
> 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

Attachment

signature.asc

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

From

Kämpf, Heiko (OWL-IT)

Date:

07 January 2021, 07:09:37

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

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

From

Kämpf, Heiko (OWL-IT)

Date:

07 January 2021, 13:00:05

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.kaempf2@owl-it.de> 
Gesendet: Donnerstag, 7. Januar 2021 08:10
An: Devrim Gündüz <devrim@gunduz.org>; Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.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
andmaintain 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
asHTML 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
befound 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
needto 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