public inbox for [email protected]  

help / color / mirror / Atom feed

From: Richard Huesken <[email protected]>
To: [email protected]
Subject: error creating postgis25 extension on postgis 11
Date: Sun, 4 Nov 2018 16:56:04 +0100
Message-ID: <CAMjmB9qFUiDuMW-vfy+vuTUyZ+kg5P9f6GsUCr+6B_QM1qsg=g@mail.gmail.com> (raw)

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.

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: error creating postgis25 extension on postgis 11
  In-Reply-To: <CAMjmB9qFUiDuMW-vfy+vuTUyZ+kg5P9f6GsUCr+6B_QM1qsg=g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox