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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16806: postgresql10 rpm is installed in the wrong directory
Дата
Msg-id 16806-f5089ccce0babcfe@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16806: postgresql10 rpm is installed in the wrong directory  (Devrim Gündüz <devrim@gunduz.org>)
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: baych igor
Дата:
Сообщение: compiling error on OpenWrt
Следующее
От: Hamid Akhtar
Дата:
Сообщение: Re: BUG #16805: "ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... PRIMARY KEY" fails if column exists and is the primary