[postgis-users] [GENERAL] Error During PostGIS Build From Source on Linux

Tue Apr 18 06:38:42 PDT 2017

Hi Regina,

This suggestion helped to resolve the problem. Thanks a lot for your help.

On Mon, Apr 17, 2017 at 11:13 AM, Osahon Oduware <osahon.gis at gmail.com>
wrote:

> Hi Regina,
>
> Thanks a lot for your help. I believe this is where the solution lies. I
> would give it another try tomorrow when I resume work from the Easter break.
>
> I will update you with my findings.
>
> On Apr 16, 2017 4:52 AM, "Regina Obe" <lr at pcorp.us> wrote:
>
>> Osahon,
>>
>>
>>
>> That error means you have installed an older version of GEOS in your
>> system and it's picking up the old one instead of the one in your
>>
>>
>>
>>   /home/nagispg/local/geos361/bin/geos-config
>>
>>
>>
>> I suspect that's the same issue with your proj too.
>>
>>
>>
>> I think doing an ldconfig after install of GEOS and proj might fix the
>> issue, but I forget.
>>
>>
>>
>> It's been a while since I've had to compile the extra dependencies even
>> if building PostGIS on Linux.
>>
>>
>>
>> Regarding the whole GDAL thing on windows.
>>
>>
>>
>> I'm the builder of the Windows application Stackbuilder PostGIS bundle
>> and also manage the Windows PostGIS buildbot.
>>
>>
>>
>> As I think someone mentioned, as a policy we don't compile any
>> proprietary extensions into the distributed windows PostGIS bundle.
>>
>> So that's one reason why Mr. SID is not included and will probably never
>> be included.
>>
>>
>>
>> However, you could convert Mr. SID format to something like OpenJpeg or
>> TIFF using GISInternals GDAL binaries for windows:
>>
>>
>>
>> http://www.gisinternals.com/release.php
>>
>>
>>
>> Last I tried, that one does have Mr. SID support.  Unfortunately you
>> can't swap out his GDAL for the ones we package.
>>
>> I was hoping I could make that possible at some point, but no free time
>> or enough funding interest to investigate.
>>
>>
>>
>> Thanks,
>>
>> Regina Obe
>>
>> PostGIS PSC member
>>
>> http://postgis.us
>>
>> http://postgis.net
>>
>>
>>
>>
>>
>>
>>
>> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
>> Behalf Of *Osahon Oduware
>> *Sent:* Friday, April 14, 2017 3:21 PM
>> *To:* Adrian Klaver <adrian.klaver at aklaver.com>
>> *Cc:* pgsql-general at postgresql.org; PostGIS Users Discussion <
>> postgis-users at lists.osgeo.org>
>> *Subject:* Re: [postgis-users] [GENERAL] 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.klaver at aklaver.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.klaver at aklaver.com
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170418/c3feaa16/attachment.html>