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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: h(dot)kaempf(at)owl-it(dot)de
Subject: BUG #16806: postgresql10 rpm is installed in the wrong directory
Date: 2021-01-05 14:47:55
Message-ID: 16806-f5089ccce0babcfe@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

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_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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hamid Akhtar 2021-01-05 15:05:46 Re: BUG #16805: "ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... PRIMARY KEY" fails if column exists and is the primary
Previous Message baych igor 2021-01-05 14:13:10 compiling error on OpenWrt