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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16806
Logged by:          heiko kaempf
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

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

Devrim GÜNDÜZ

Hi,

On Tue, 2021-01-05 at 14:47 +0000, PG Bug reporting form wrote:

>
> Bug reference:      16806
> Logged by:          heiko kaempf
> Email address:      [hidden email]
> 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

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

Kämpf, Heiko (OWL-IT)
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 <[hidden email]>
Gesendet: Mittwoch, 6. Januar 2021 18:53
An: Kämpf, Heiko (OWL-IT) <[hidden email]>; [hidden email]
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:      [hidden email] 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
Reply | Threaded
Open this post in threaded view
|

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

Kämpf, Heiko (OWL-IT)
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) <[hidden email]>
Gesendet: Donnerstag, 7. Januar 2021 08:10
An: Devrim Gündüz <[hidden email]>; Kämpf, Heiko (OWL-IT) <[hidden email]>; [hidden email]
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 <[hidden email]>
Gesendet: Mittwoch, 6. Januar 2021 18:53
An: Kämpf, Heiko (OWL-IT) <[hidden email]>; [hidden email]
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:      [hidden email] 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