Re: Error During PostGIS Build From Source on Linux

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(dot)klaver(at)aklaver(dot)com> 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(dot)klaver(at)aklaver(dot)com