[postgis-users] Problems while loading lwpostgis.sql...Pleaseprovide your inputs / help
Paul Ramsey
pramsey at refractions.net
Wed Jan 30 08:29:08 PST 2008
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 at wipro.com> <ahmadbasha.shaik at 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 at postgis.refractions.net
> [mailto:postgis-users-bounces at 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 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
>
> _______________________________________________
> 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
More information about the postgis-users
mailing list