[postgis-users] facing problems while loading lwpostgis.sql inPostGIS

[Mark Cave-Ayland]

On Fri, 2008-02-01 at 12:20 +0530, ahmadbasha.shaik at wipro.com wrote:
> Tim,
> 
> 	Thanks for your inputs, We had installed Postgresql using the
> following switches
> 
> 	./configure
> 	make
> 	make install	
> 
> 	Secondly, the results of ldd /usr/local/pgsql/lib/liblwgeom.so
> gives no such file or directory
> 	
> 	Then I did ldd on the /usr/lib/pgsql/liblwgeom.so (as this file
> was in this directory) 
> 
>         libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x00d6e000)
>         libproj.so.0 => /usr/local/lib/libproj.so.0 (0x005ac000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x001dd000)
>         libgeos-3.0.0.so => /usr/local/lib/libgeos-3.0.0.so (0x00621000)
>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00dae000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x00111000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x0058e000)
>         /lib/ld-linux.so.2 (0x003fa000)
> 
> Additionally wanted to provide you the following information, maybe you
> might give us some inputs on the installation
> /*******************************************************************/
> SUMMARY
>  -------------------------------------------------------
> 
>  HOST_OS: linux-gnu
> 
>    PGSQL: /usr/bin/pg_config
>     GEOS: /usr/local/bin/geos-config (with C-API)
>           (ldflags: -L/usr/local/lib)
>     PROJ: prefix=/usr/local libdir=/usr/local/lib
>    ICONV: 1
> 
>  PORTNAME: linux
>    PREFIX: /usr
>   EPREFIX: ${prefix}
>       DOC: /usr/share/doc/postgresql/contrib
>      DATA: ${datarootdir}
>       MAN: ${datarootdir}/man
>       BIN: /usr/bin
>       EXT: /usr/lib/pgsql (\$$libdir)
> /*******************************************************************/
> 
> Regards
> Ahmad 


Hi Ahmad,

It looks like you have two installations of PostgreSQL - one with
libraries in /usr/lib/pgsql (which is probably already installed via
RPMs) and your new 8.2.6 installation in /usr/local/pgsql.

Unfortunately it looks as if ./configure for PostGIS has picked up the
wrong one, so you need to do a "make clean" on your PostGIS installation
and then rebuild like this:

./configure --with-pgsql=/usr/local/bin/pg_config
make
make install

This should then put the libraries in /usr/local/pgsql/lib and hence
should allow you to install lwpostgis.sql.


HTH,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk