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