Обсуждение: BUG #16806: postgresql10 rpm is installed in the wrong directory
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
Hi, On Tue, 2021-01-05 at 14:47 +0000, PG Bug reporting form wrote: > > 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. 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
Вложения
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 <devrim@gunduz.org> Gesendet: Mittwoch, 6. Januar 2021 18:53 An: Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.org 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: 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_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-providedpackages? 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
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) <h.kaempf2@owl-it.de> Gesendet: Donnerstag, 7. Januar 2021 08:10 An: Devrim Gündüz <devrim@gunduz.org>; Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.org 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 andmaintain 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 asHTML 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 befound 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 needto 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 <devrim@gunduz.org> Gesendet: Mittwoch, 6. Januar 2021 18:53 An: Kämpf, Heiko (OWL-IT) <h.kaempf@owl-it.de>; pgsql-bugs@lists.postgresql.org 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: 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_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-providedpackages? 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