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 <[email protected]> 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" <[email protected]> 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:[email protected]] *On >> Behalf Of *Osahon Oduware >> *Sent:* Friday, April 14, 2017 3:21 PM >> *To:* Adrian Klaver <[email protected]> >> *Cc:* [email protected]; PostGIS Users Discussion < >> [email protected]> >> *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" <[email protected]> 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 >> [email protected] >> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
