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

[Tim Bowden]

On Wed, 2008-01-30 at 19:05 +0530, ahmadbasha.shaik at 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 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
>         
> 
> 
> 
> 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