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

[Daryl Herzmann]

Greetings,

This issue was filed with the RPM packager here:

https://redmine.postgresql.org/issues/3710

daryl
On Tue, Oct 30, 2018 at 3:30 PM Richard Huesken
<richard.huesken at gmail.com> wrote:
>
> 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.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users