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 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:* *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* I would be glad if someone could point me to what I am doing wrong and possible solution. On Thu, Apr 13, 2017 at 3:00 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 04/13/2017 02:46 AM, Osahon Oduware wrote: > >> Hi Adrian, >> >> I followed the step you provided and the installation was successful. >> However, I created a test database and when I try to create a postgis >> extension in the test database using: >> CREATE EXTENSION postgis; >> >> I get the following error: >> ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so >> <http://postgis-2.3.so>": /path/to/postgresql/lib/postgis-2.3.so >> <http://postgis-2.3.so>: undefined symbol: GEOSClipByRect >> >> Please, do you have any idea what I might be doing wrong? >> >> > Should have added to my previous post: > > 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. > > In my case: > > PostGIS is now configured for x86_64-pc-linux-gnu > > -------------- Compiler Info ------------- > C compiler: gcc -g -O2 > SQL preprocessor: /usr/bin/cpp -traditional-cpp -w -P > > -------------- Dependencies -------------- > GEOS config: /usr/bin/geos-config > GEOS version: 3.5.1 > GDAL config: /home/aklaver/gdal/bin/gdal-config > GDAL version: 2.1.3 > PostgreSQL config: /usr/local/pgsql/bin/pg_config > PostgreSQL version: PostgreSQL 9.5.6 > PROJ4 version: 49 > Libxml2 config: /usr/bin/xml2-config > Libxml2 version: 2.9.4 > JSON-C support: no > PCRE support: yes > PostGIS debug level: 0 > Perl: /usr/bin/perl > > --------------- Extensions --------------- > PostGIS Raster: enabled > PostGIS Topology: enabled > SFCGAL support: disabled > Address Standardizer support: enabled > > -------- 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 > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
