[postgis-users] Problems while loading lwpostgis.sql... Pleaseprovide your inputs / help

[ahmadbasha.shaik at wipro.com]

Yes andy
 
    a) /usr/local/lib was already present in /etc/ld.so.conf
    b) ldconfig was also performed
 
    Can you please let me know what else might be the problem as I am in
a urgency to load GIS data in PostgreSQL (with Post GIS).
 
Regards
Ahmad

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Andy
Dale
Sent: Wednesday, January 30, 2008 6:53 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems while loading lwpostgis.sql...
Pleaseprovide your inputs / help


Hi,

Have you added /usr/local/lib to /etc/ld.so.conf and then performed a
ldconfig ?

Cheers,

Andy


On 30/01/2008, ahmadbasha.shaik at wipro.com <ahmadbasha.shaik at wipro.com>
wrote: 

	Hi 
	 
	I am facing problems while loading lwpostgis.sql in PostGIS.
Below is a detailed explanation.
	psql -d test -f /usr/share/lwpostgis.sql
	 
	
/***********************************************************************
*******/
	ERROR:  could not access file "$libdir/liblwgeom.so.1.2": No
such file or directory
	ERROR:  current transaction is aborted, commands ignored until
end of transaction block
	
/***********************************************************************
*******/
	 
	
	Hence , I tried creating a simple test.sql which has the create
replace functions for histogram. I have detailed the environmnent that
we are 
	using, the statement of lwpostgis.sql we executed and the error
encountered 
	 
	Environment:
	============
	Operationg System : Red Hat Linux 3.4.5-2
	Database : PostgreSQL 8.2.6 
	Extensions : geos-3.0.0, proj-4.6.0, postgis-1.2.1
	 
	test.sql (three sql commands that I have taken from
lwpostgis.sql to check)
	========
	
	BEGIN;
	 
	CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
	        RETURNS histogram2d
	        AS '$libdir/liblwgeom.so.1.2', 'lwhistogram2d_in'
	        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
	 
	CREATE OR REPLACE FUNCTION histogram2d_out(histogram2d)
	        RETURNS cstring
	        AS '$libdir/liblwgeom.so.1.2', 'lwhistogram2d_out'
	        LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
	 
	CREATE TYPE histogram2d (
	        alignment = double,
	        internallength = variable,
	        input = histogram2d_in,
	        output = histogram2d_out,
	        storage = main
	);
	 
	COMMIT;
	 
	 
	ERROR Encountered
	================
	 
	BEGIN
	psql:test.sql:6: NOTICE:  type "histogram2d" is not yet defined
	DETAIL:  Creating a shell type definition.
	psql:test.sql:6: ERROR:  could not access file
"$libdir/liblwgeom.so.1.2": No such file or directory
	psql:test.sql:11: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
	psql:test.sql:19: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
	ROLLBACK
	 
	Varions Options we tried:
	==================
	a) Changed the permissions $libdir i.e. /usr/lib/pgsl to 777
	b) Hardcoded the path /usr/lib/pgsql in this test.sql
	c) We also tried hardcoding the path /usr/lib/pgsql instead of
$libdir in lwpostgis.sql when we tried loading functions and types in
lwpostgis.sql
	 
	
	Can somebody please guide us or give directions what can be
done. 
	 
	Regards
	Ahmad

	P 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
	
	



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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080130/5cc303aa/attachment.html>