[postgis-users] Fwd: Problem creating postgis (2.5) extension with postgres 11 - SOLVED

[Richard Huesken]

Hi,

My issue has been solved by a tip from Raúl Marín Rodríguez, who pointed
out that geod_polygon_init was introduced in PROJ 4.9.1 and it appears I
was using 4.8.0-4.el7.
This was most likely caused by a packaging issue, I created a ticket for
this issue at: www.postgresql.org (#15472).


[root at 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 at 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 at 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 at ol-pg11 lib]# cd /lib64/
[root at 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 at ol-pg11 lib64]# find / -name libproj.so.12
/usr/proj49/lib/libproj.so.12

Once the symlink was changed, I was able to create Postgis Extensions in
the Postgres 11 database:

[root at ol-pg11 lib64]# rm libproj.so.0
rm: remove symbolic link ‘libproj.so.0’? y
[root at ol-pg11 lib64]# ls -l *proj*
-rwxr-xr-x. 1 root root 338168 Jan 24  2014 libproj.so.0.7.0

[root at ol-pg11 lib64]# ln -s /usr/proj49/lib/libproj.so.12 libproj.so.0
[root at ol-pg11 lib64]# ls -l *proj*
lrwxrwxrwx. 1 root root     29 Oct 30 10:24 libproj.so.0 ->
/usr/proj49/lib/libproj.so.12
-rwxr-xr-x. 1 root root 338168 Jan 24  2014 libproj.so.0.7.0


PSQL output:

psql (11.0)
Type "help" for help.

testgeo=# \dx
                                     List of installed extensions
  Name   | Version |   Schema   |                             Description
---------+---------+------------+---------------------------------------------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis | 2.5.0   | public     | PostGIS geometry, geography, and raster
spatial types and functions


---------- Forwarded message ---------
From: Richard Huesken <richard.huesken at gmail.com>
Date: ma 29 okt. 2018 om 13:58
Subject: Problem creating postgis (2.5) extension with postgres 11
To: <postgis-users at lists.osgeo.org>


Hi,

I'm having troubles creating a postgis extension in a postgres11 database
(running on Oracle Enterprise Linux 7).

As postgres user in the testgeo database I run:
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
  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

Can somebody please point out what I'm doing wrong ?

Installed packages:

[root at ol-pg11 Downloads]# yum list installed | grep postgresql11
postgresql11.x86_64                    11.0-1PGDG.rhel7            @pgdg11
postgresql11-contrib.x86_64            11.0-1PGDG.rhel7            @pgdg11
postgresql11-libs.x86_64               11.0-1PGDG.rhel7            @pgdg11
postgresql11-plpython.x86_64           11.0-1PGDG.rhel7            @pgdg11
postgresql11-server.x86_64             11.0-1PGDG.rhel7            @pgdg11
[root at ol-pg11 Downloads]# yum list installed | grep postgis25
postgis25_11.x86_64                    2.5.0-1.rhel7.1             @pgdg11
postgis25_11-client.x86_64             2.5.0-1.rhel7.1             @pgdg11
[root at ol-pg11 Downloads]# 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

Thanks in advance,

Richard.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181030/489abbc9/attachment.html>