[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Fwd: Problem creating postgis (2.5) extension with postgres 11 - SOLVED
From:       Daryl Herzmann <akrherz () gmail ! com>
Date:       2018-11-01 13:06:42
Message-ID: CALOVXPe5Od50+E=Wrz_s4F3v+emPeK9DwfbhtcZMfbTV4f7RrQ () mail ! gmail ! com
[Download RAW message or body]

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@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@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
> 
> Once the symlink was changed, I was able to create Postgis Extensions in the \
> Postgres 11 database: 
> [root@ol-pg11 lib64]# rm libproj.so.0
> rm: remove symbolic link ‘libproj.so.0'? y
> [root@ol-pg11 lib64]# ls -l *proj*
> -rwxr-xr-x. 1 root root 338168 Jan 24  2014 libproj.so.0.7.0
> 
> [root@ol-pg11 lib64]# ln -s /usr/proj49/lib/libproj.so.12 libproj.so.0
> [root@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@gmail.com>
> Date: ma 29 okt. 2018 om 13:58
> Subject: Problem creating postgis (2.5) extension with postgres 11
> To: <postgis-users@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@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@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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]