Re: Error During PostGIS Build From Source on Linux

[Osahon Oduware <osahon.gis@xxxxxxxxx>]

Hi Adrian,

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:

ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

I will be glad if anyone could help with this.

On Apr 13, 2017 18:27, "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx> wrote:

On 04/13/2017 07:54 AM, Osahon Oduware wrote:

Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to

configure PostGIS (I think I read somewhere in the documentation that

the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*

How did you install Proj, from a package or source?

*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*

First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.

I would be glad if someone could point me to what I am doing wrong and
possible solution.

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx