[postgis-users] facing problems while loading lwpostgis.sqlinPostGIS

[Tim Bowden]

Ahmad,

I have previously asked you to provide several pieces of information
which you have not provided.  Both Mark and myself have indicated that
we believe you have postgresql already installed from rpm as well as the
source install you're trying to do, but you have failed to confirm this.
Nobody can help you if you won't provide the information asked for.

Tim Bowden

On Fri, 2008-02-01 at 14:45 +0530, ahmadbasha.shaik at wipro.com wrote:
> Tim, 
> 
> 	Thanks once again, 
> 
> As per the installation document, PostgreSQL is required to be installed
> before installing PostGIS.
> 	
> Secondly, we did do a make clean of Postgis, PostgreSQL, Geos and Proj4
> and then installed all of them. We carried out this activity thrice but
> could not succeed.
> 
> In this path that you had mentioned 
> ./configure --with-pgsql=/usr/local/bin/pg_config
> 
> Are you referring to /usr/local/pgsql/bin/pgs_config because the above
> path does not exist.
> 
> Please help us as we are really stuck at this point.
> 
> Regards
> Ahmad
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Tim
> Bowden
> Sent: Friday, February 01, 2008 1:08 PM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] facing problems while loading
> lwpostgis.sqlinPostGIS
> 
> 
> 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.
> > 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> Please do not print this email unless it is absolutely necessary. Spread environmental awareness.
> 
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. 
> 
> WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 
> 
> www.wipro.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users