<div dir="ltr"><div><div>Hi Adrian,<br><br>Thanks for your help so far. This is the output of the PostGIS 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/<wbr>bin/geos-config<br> GEOS version: 3.6.1<br> GDAL config: /home/nagispg/local/gdal213/<wbr>bin/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" target="_blank">http://www.w3.org/Math/DTD/<wbr>mathml2/mathml2.dtd</a><br><br></div>I had to install a <b>higher version of Proj (4.9.3)</b> that was used to configure PostGIS (I think I read somewhere in the documentation that the version of Proj should be >= 4.6.0). <b>Now, I get the following error when I run CREATE EXTENSION postgis:</b><br><br><b>ERROR: could not load library <a href="http://postgis-2.3.so" target="_blank">postgis-2.3.so</a>: libproj.so.12: cannot open shared object file: No such file or directory</b><br><br></div>I would be glad if someone could point me to what I am doing wrong and possible solution.<br><div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 13, 2017 at 3:00 PM, Adrian Klaver <span dir="ltr"><<a href="mailto:adrian.klaver@aklaver.com" target="_blank">adrian.klaver@aklaver.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>On 04/13/2017 02:46 AM, Osahon Oduware wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>
Hi Adrian,<br>
<br>
I followed the step you provided and the installation was successful.<br>
However, I created a test database and when I try to create a postgis<br>
extension in the test database using:<br>
CREATE EXTENSION postgis;<br>
<br>
I get the following error:<br>
ERROR: could not load library "/path/to/postgresql/lib/<a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postg<wbr>is-2.3.so</a><br></span>
<<a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">http://postgis-2.3.so</a>>": /path/to/postgresql/lib/<a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">postgi<wbr>s-2.3.so</a><br>
<<a href="http://postgis-2.3.so" rel="noreferrer" target="_blank">http://postgis-2.3.so</a>>: undefined symbol: GEOSClipByRect<span><br>
<br>
Please, do you have any idea what I might be doing wrong?<br>
<br>
</span></blockquote>
<br>
Should have added to my previous post:<br>
<br>
If you are going to compile the code, the output at the end of the ./configure process for Postgis is helpful. It helps identify what is going to be included and what is not.<br>
<br>
In my case:<br>
<br>
PostGIS is now configured for x86_64-pc-linux-gnu<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: /usr/bin/geos-config<br>
GEOS version: 3.5.1<br>
GDAL config: /home/aklaver/gdal/bin/gdal-co<wbr>nfig<br>
GDAL version: 2.1.3<br>
PostgreSQL config: /usr/local/pgsql/bin/pg_config<br>
PostgreSQL version: PostgreSQL 9.5.6<br>
PROJ4 version: 49<br>
Libxml2 config: /usr/bin/xml2-config<br>
Libxml2 version: 2.9.4<br>
JSON-C support: no<br>
PCRE support: yes<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: enabled<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><span class="m_3754567391411073213HOEnZb"><font color="#888888"><br>
<br>
-- <br>
Adrian Klaver<br>
<a href="mailto:adrian.klaver@aklaver.com" target="_blank">adrian.klaver@aklaver.com</a><br>
</font></span></blockquote></div><br></div></div>