Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJLrp-0005dr-0B for pgsql-pkg-yum@arkaria.postgresql.org; Sun, 04 Nov 2018 17:07:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gJLrn-0000l9-G2 for pgsql-pkg-yum@arkaria.postgresql.org; Sun, 04 Nov 2018 17:07:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJKl8-0006kS-SU for pgsql-pkg-yum@lists.postgresql.org; Sun, 04 Nov 2018 15:56:19 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gJKl6-0007Mz-2h for pgsql-pkg-yum@postgresql.org; Sun, 04 Nov 2018 15:56:17 +0000 Received: by mail-oi1-x232.google.com with SMTP id v198-v6so5445083oif.2 for ; Sun, 04 Nov 2018 07:56:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=6+68CWd8rVrf/NMmftgaIkvwS8vZQHcmSeiy2LUAbZI=; b=M1oC1+hL/bYNrraBJOxz+BspLHvGcSoV60eJcyyfA5r6iOCI/dEGHi/CyZhDxPQ/PF ZME+Ma16vBoNGFaHFcgRm0E8whLs3yRyRWw3hk8B/HDUL2ZlgCBpMdeMS2BRg3iTRS+G 5helrRh/YSrIbCgXBuyipJpaZsuzU2oa4IXUBH94KVtIU0IAkD/XOGYcycMxW8ND7wph ru7j+FtlCTtlfrxvamEMNVaagNOabDZhuSVfCEtLK728Z9Vz3kkGu1iTedwa1xZtIqHY qGWP2YeI/tiTsJKss9i4eBlL+IIm0Z8woCRg2aglv9v3tdYIRePo3io/dKucuKEkUWmF 0aiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=6+68CWd8rVrf/NMmftgaIkvwS8vZQHcmSeiy2LUAbZI=; b=bc34C6ZZaKuFEhM/t3kbl+D/7XpT9mnKvOf6pLvrJIknQFGxGg63VRG5Ve5vtoFT1a KLBdvkvsg0M2kXbylpUMC5c/oYwb15TZ5m6SB8Bh/w6RCERgXDE9Fa7in0Jcy9FOS5TB qw39L2IFemFf9YxcrcszLuQ1DrfTIAbZL1ynAngvLlB3dyEHsRGKkaiZAosuJTs/t9mx Y76f5EbmtJboSZNfrojoiXhGhJGrjy975qSCefwC25NkGfjd88lluPYqnY7jL1Ren7+m wK1plXipiKGtw95UA9Gw0GK9zUubDOlWg4uJ+0ybw8s6U7WrdOP6clstmpCm8KuY13Jx lcZQ== X-Gm-Message-State: AGRZ1gIHheOJX8bhho6f1tZeF29PauBc0YHep45X5BslaLHOKxsIP+hY dJP9j29mnmXppCoT9GjeVv1/HbFzXgd7BLiLW0hehlsS X-Google-Smtp-Source: AJdET5eriPnSlDh2YrIG6OQSPxp+ZWZQNmHgs7mEUfR0z2A7WQWXo19fiC0lSPbcF9gCl65VRrbBb1bgiLdrNTLXfwY= X-Received: by 2002:aca:8b:: with SMTP id 133-v6mr10571777oia.97.1541346975307; Sun, 04 Nov 2018 07:56:15 -0800 (PST) MIME-Version: 1.0 From: Richard Huesken Date: Sun, 4 Nov 2018 16:56:04 +0100 Message-ID: Subject: error creating postgis25 extension on postgis 11 To: pgsql-pkg-yum@postgresql.org Content-Type: multipart/alternative; boundary="000000000000f059b60579d8ce21" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000f059b60579d8ce21 Content-Type: text/plain; charset="UTF-8" Hi, On my Oracle Linux 7 box I had troubles vreating a postgis extension: create extension postgis The error is: SQL Error [XX000]: ERROR: could not load library "/usr/pgsql-11/lib/ postgis-2.5.so": /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.5.so": /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init This might be a packaging error in the postgis25_11 package for Oracle Linux 7. I tried to create a ticket for this issue, however I'm not sure if this worked out correctly. I'm sending this mail just to be sure... [root@ol-pg11 lib64]# uname -a Linux ol-pg11.rihu-ho 4.1.12-124.20.7.el7uek.x86_64 #2 SMP Wed Oct 24 14:15:06 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux [root@ol-pg11 ~]# yum list installed | grep proj proj.x86_64 4.8.0-4.el7 @epel proj49.x86_64 4.9.3-3.rhel7.1 @pgdg11 Indeed there are 2 dependencies in my postgis25_11 package: [root@ol-pg11 ~]# yum deplist postgis25_11 Loaded plugins: langpacks, ulninfo package: postgis25_11.x86_64 2.5.0-1.rhel7.1 ... dependency: libproj.so.0()(64bit) provider: proj.x86_64 4.8.0-4.el7 dependency: libproj.so.12()(64bit) provider: proj49.x86_64 4.9.3-3.rhel7.1 ... postgis-2.5.so seems to be using the one in the /lib64 directory: [root@ol-pg11 lib]# ldd postgis-2.5.so ... libproj.so.0 => /lib64/libproj.so.0 (0x00007f6792485000) ... The proj4.8 version is located in /lib64 [root@ol-pg11 lib]# cd /lib64/ [root@ol-pg11 lib64]# ls -l libproj.so* lrwxrwxrwx. 1 root root 16 Oct 29 13:36 libproj.so.0 -> libproj.so.0.7.0 -rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0 Whereas the proj4.9 version is located in /usr/proj49/lib [root@ol-pg11 lib64]# find / -name libproj.so.12 /usr/proj49/lib/libproj.so.12 The postgis25_11 package should only reference the the proj4.9 version. Once I fix this manually by changing the symlink I am able to create the postgis extension. The permanent option is to fix the package, hope you agree on this, Kind regards, Richard. --000000000000f059b60579d8ce21 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

On my O= racle Linux 7 box I had troubles vreating a postgis extension:
create extension postgis


The error is:
SQL Error [XX000]: ERROR: could not load library= "/usr/pgsql-11/lib/postgis-2.5.so": /usr/pgsql-11/lib/postgis-2.5.s= o: undefined symbol: geod_polygon_init
=C2=A0 ERROR: could no= t load library "/usr/pgsql-11/lib/po= stgis-2.5.so": /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init

This might be a packaging error in the postgis25_11 package for Orac= le Linux 7.
I tried to create a ticket for this issue, however I&= #39;m not sure if this worked out correctly.

I'= ;m sending this mail just to be sure...=C2=A0


=
[root@ol-pg11 lib64]# uname -a
Linux ol-pg11.rihu-ho 4= .1.12-124.20.7.el7uek.x86_64 #2 SMP Wed Oct 24 14:15:06 PDT 2018 x86_64 x86= _64 x86_64 GNU/Linux


[root@ol-pg11 = ~]# yum list installed | grep proj
proj.x86_64=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 4.8.0-4.el7=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0@epel
proj49.x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 4.9.3-3.rhel7.1=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0@pgdg11

I= ndeed there are 2 dependencies in my postgis25_11 package:

[root@ol-pg11 ~]# yum deplist postgis25_11
Loaded plugin= s: langpacks, ulninfo
package: postgis25_11.x86_64 2.5.0-1.rhel7.= 1
...
=C2=A0 dependency: libproj.so.0()(64bit)
=C2=A0 =C2=A0provider: proj.x86_64 4.8.0-4.el7
=C2=A0 dependenc= y: libproj.so.12()(64bit)
=C2=A0 =C2=A0provider: proj49.x86_64 4.= 9.3-3.rhel7.1
...

postgis-2.5.so seems to be using the one in the /lib64 dire= ctory:

[root@ol-pg11 lib]# ldd postgis-2.5.so
...
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 libproj.so.0 =3D> /lib64/libproj.so.0 (0x00007f6792485000)
...

The proj4.8 version is located in /lib= 64

[root@ol-pg11 lib]# cd /lib64/
[root@= ol-pg11 lib64]# ls -l libproj.so*
lrwxrwxrwx. 1 root root=C2=A0 = =C2=A0 =C2=A016 Oct 29 13:36 libproj.so.0 -> libproj.so.0.7.0
= -rwxr-xr-x. 1 root root 338168 Jan 24=C2=A0 2014 libproj.so.0.7.0

Whereas the proj4.9 version is located in /usr/proj49/lib

[root@ol-pg11 lib64]# find / -name libproj.so.12
/usr/proj49/lib/libproj.so.12

The postgis2= 5_11 package should only reference the the proj4.9 version.
Once = I fix this manually by changing the symlink I am able to create the postgis= extension.

The permanent option is to fix the pac= kage, hope you agree on this,

Kind regards,
<= div>Richard.

--000000000000f059b60579d8ce21--