Re: Error During PostGIS Build From Source on Linux

[Osahon Oduware <osahon.gis@xxxxxxxxx>]

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: 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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx