resending... -------- Forwarded Message -------- From: Tim Bowden <[EMAIL PROTECTED]> To: PostGIS Users Discussion <[email protected]> Subject: RE: [postgis-users] Problems while loadinglwpostgis.sql...Pleaseprovide your inputs / help Date: Thu, 31 Jan 2008 13:41:04 +0900
On Thu, 2008-01-31 at 09:29 +0530, [EMAIL PROTECTED] wrote: > Hey Paul > > Please give me your inputs as to what could be the problem with > regards to the environment. > > Yes this liblwgeom.so.1.2 file actually exists. Following is the ls -ltr > listing of /usr/lib/pgsql > > lrwxrwxrwx 1 root root 16 Jan 30 16:24 liblwgeom.so -> > liblwgeom.so.1.2 > lrwxrwxrwx 1 root root 16 Jan 30 16:24 liblwgeom.so.1 -> > liblwgeom.so.1.2 > -rwxrwxrwx 1 root root 894867 Jan 30 16:24 liblwgeom.so.1.2 You indirectly indicated earlier that you installed to /usr/local/pgsql so why are these files in /usr/lib/pgsql? How did you install postrgresql and postgis? Tim Bowden > > Please provide your inputs. > > Regards > Ahmad > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Paul > Ramsey > Sent: Wednesday, January 30, 2008 9:59 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Problems while > loadinglwpostgis.sql...Pleaseprovide your inputs / help > > This is certainly an environment problem, not a software problem... > > You have confirmed that liblwgeom.so.1.2 actually exists? > > On Jan 30, 2008, at 6:22 AM, <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] > wrote: > > > Hey Tim > > > > That entry also is there in /etc/ld.so.conf file. Please let me > know > > if there is any other way out. > > > > Regards > > Ahmad > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Tim Bowden > > Sent: Wednesday, January 30, 2008 7:27 PM > > To: PostGIS Users Discussion > > Subject: RE: [postgis-users] Problems while loading > > lwpostgis.sql...Pleaseprovide your inputs / help > > > > > > On Wed, 2008-01-30 at 19:05 +0530, [EMAIL PROTECTED] wrote: > >> Yes andy > >> > >> a) /usr/local/lib was already present in /etc/ld.so.conf > >> b) ldconfig was also performed > > > > If you've used the default source install of postgresql, you'll need > > /usr/local/pgsql/lib > > > > HTH, > > Tim Bowden > > > >> > >> 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: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] 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, [EMAIL PROTECTED] > >> <[EMAIL PROTECTED]> > >> 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 > >> [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > >> > >> > >> > >> 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 > >> [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > 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 > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
