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 по дате отправления:
Следующее
От: Hamid AkhtarДата:
Сообщение: Re: BUG #16805: "ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... PRIMARY KEY" fails if column exists and is the primary