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

[Tim Bowden]

On Fri, 2008-02-01 at 07:28 +0000, Mark Cave-Ayland wrote:
> 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.

I vaguely recall there was a requirement for postgresql to be run before
installing postgis.  Is this still the case, or have I not correctly
remembered?

Tim Bowden

> 
> 
> HTH,
> 
> Mark.
>