[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [Fwd: RE: [postgis-users] Problems while
From: Tim Bowden <tim.bowden () westnet ! com ! au>
Date: 2008-01-31 6:59:26
Message-ID: 1201762766.6849.18.camel () edoras
[Download RAW message or body]
resending...
-------- Forwarded Message --------
From: Tim Bowden <tim.bowden@westnet.com.au>
To: PostGIS Users Discussion <postgis-users@postgis.refractions.net>
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, ahmadbasha.shaik@wipro.com 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: postgis-users-bounces@postgis.refractions.net
> [mailto:postgis-users-bounces@postgis.refractions.net] 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, <ahmadbasha.shaik@wipro.com>
> <ahmadbasha.shaik@wipro.com > 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: postgis-users-bounces@postgis.refractions.net
> > [mailto:postgis-users-bounces@postgis.refractions.net] 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, ahmadbasha.shaik@wipro.com 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: postgis-users-bounces@postgis.refractions.net
> > > [mailto:postgis-users-bounces@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@wipro.com
> > > <ahmadbasha.shaik@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@postgis.refractions.net
> > > 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
> > > postgis-users@postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@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@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic