<div dir="auto">Hi Adrian,<div dir="auto"><br></div><div dir="auto">I installed Proj from source and I can confirm that the file <span style="font-family:sans-serif">libproj.so.12 is in its lib folder.</span></div><div dir="auto"><span style="font-family:sans-serif"><br></span></div><div dir="auto"><span style="font-family:sans-serif">I have not been able to confirm if it is linked to </span><a href="http://postgis-2.3.so/" style="font-family:sans-serif">postgis-2.3.so</a><span style="font-family:sans-serif"> as I am away for Easter holiday.</span></div><div dir="auto"><span style="font-family:sans-serif"><br></span></div><div dir="auto"><span style="font-family:sans-serif">Just in case, how do I do the linking of </span><span style="font-family:sans-serif">libproj.so.12</span><span style="font-family:sans-serif"> to </span><a href="http://postgis-2.3.so/" style="font-family:sans-serif">postgis-2.3.so</a> 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:</div><div dir="auto"><span style="font-family:sans-serif;font-size:13.696px">ERROR: could not load library "/path/to/postgresql/lib/</span><a href="http://postgis-2.3.so/" style="text-decoration:none;color:rgb(66,133,244);font-family:sans-serif;font-size:13.696px">postg<wbr>is-2.3.so</a><span style="font-family:sans-serif;font-size:13.696px">": /path/to/postgresql/lib/</span><a href="http://postgis-2.3.so/" style="text-decoration:none;color:rgb(66,133,244);font-family:sans-serif;font-size:13.696px">postgi<wbr>s-2.3.so</a><span style="font-family:sans-serif;font-size:13.696px">: undefined symbol: GEOSClipByRect</span><br></div><div dir="auto"><br></div><div dir="auto">I will be glad if anyone could help with this.</div><div dir="auto"><br></div><div class="gmail_extra" dir="auto"><div class="gmail_quote">On Apr 13, 2017 18:27, "Adrian Klaver" <<a href="mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>> wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="quoted-text">On 04/13/2017 07:54 AM, Osahon Oduware wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Adrian,<br>
<br><div class="elided-text">
Thanks for your help so far. This is the output of the PostGIS<br>
configuration:<br>
<br>
-------------- Compiler Info -------------<br>
C compiler: gcc -g -O2<br>
SQL preprocessor: /usr/bin/cpp -traditional-cpp -w -P<br>
<br>
-------------- Dependencies --------------<br>
GEOS config: /home/nagispg/local/geos361/bi<wbr>n/geos-config<br>
GEOS version: 3.6.1<br>
GDAL config: /home/nagispg/local/gdal213/bi<wbr>n/gdal-config<br>
GDAL version: 2.1.3<br>
PostgreSQL config: /home/nagispg/local/pgsql/bin/<wbr>pg_config<br>
PostgreSQL version: PostgreSQL 9.6.2<br>
PROJ4 version: 49<br>
Libxml2 config: /usr/bin/xml2-config<br>
Libxml2 version: 2.7.6<br>
JSON-C support: no<br>
PCRE support: no<br>
PostGIS debug level: 0<br>
Perl: /usr/bin/perl<br>
<br>
--------------- Extensions ---------------<br>
PostGIS Raster: enabled<br>
PostGIS Topology: enabled<br>
SFCGAL support: disabled<br>
Address Standardizer support: disabled<br>
<br>
-------- Documentation Generation --------<br>
xsltproc: /usr/bin/xsltproc<br>
xsl style sheets:<br>
dblatex:<br>
convert: /usr/bin/convert<br>
mathml2.dtd: <a href="http://www.w3.org/Math/DTD/mathml2/mathml2.dtd" rel="noreferrer" target="_blank">http://www.w3.org/Math/DTD/mat<wbr>hml2/mathml2.dtd</a><br>
<<a href="http://www.w3.org/Math/DTD/mathml2/mathml2.dtd" rel="noreferrer" target="_blank">http://www.w3.org/Math/DTD/ma<wbr>thml2/mathml2.dtd</a>><br>
<br></div>
I had to install a *higher version of Proj (4.9.3)* that was used to<div class="quoted-text"><br>
configure PostGIS (I think I read somewhere in the documentation that<br></div>
the version of Proj should be >= 4.6.0). *Now, I get the following error<br>
when I run CREATE EXTENSION postgis:*<br>
</blockquote>
<br>
How did you install Proj, from a package or source?<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
*ERROR: could not load library <a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postgis-2.3.so</a> <<a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">http://postgis-2.3.so</a>>:<br>
libproj.so.12: cannot open shared object file: No such file or directory*<br>
</blockquote>
<br>
First find <a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postgis-2.3.so</a> and do:<br>
<br>
ldd <a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postgis-2.3.so</a><br>
<br>
It should show something like:<br>
<br>
linux-vdso.so.1 (0x00007ffe3ed8a000)<br>
libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)<br>
==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)<br>
libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)<br>
libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)<br>
libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)<br>
<a href="http://libgeos-3.5.1.so" rel="noreferrer" target="_blank">libgeos-3.5.1.so</a> => /usr/lib64/<a href="http://libgeos-3.5.1.so" rel="noreferrer" target="_blank">libgeos-3.5.1.so</a> (0x00007f975acef000)<br>
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)<br>
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)<br>
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)<br>
libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)<br>
libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)<br>
liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)<br>
/lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)<br>
<br>
That will verify if <a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postgis-2.3.so</a> is linked to libproj.<div class="elided-text"><br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
I would be glad if someone could point me to what I am doing wrong and<br>
possible solution.<br>
<br>
<br>
</blockquote>
<br></div><font color="#888888">
-- <br>
Adrian Klaver<br>
<a href="mailto:adrian.klaver@aklaver.com" target="_blank">adrian.klaver@aklaver.com</a><br>
</font></blockquote></div><br><br></div></div>