[postgis-users] postgis.sql giving error on libgeos

Paul Ramsey pramsey at refractions.net
Tue Oct 26 13:48:34 PDT 2004


Packages for both geos and postgis?


David Bitner wrote:

> No, I had tried to build GEOS, but was never able to get it compiled so I am
> using the package on blastwave.org for solaris.
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
> Ramsey
> Sent: Tuesday, October 26, 2004 2:56 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] postgis.sql giving error on libgeos
> 
> 
> Any chance you have old versions of GEOS lying around on that machine in
> surprising places?
> 
> 
> David Bitner wrote:
> 
> 
>>I am not sure if I have gone forwards or backwards, but when I restarted
>>postmaster, left my shell as my postgres user, came back to the shell, and
>>unset LD_LIBRARY_PATH I now get the following error:
>>
>>psql:postgis.sql:47: NOTICE:  type "histogram2d" is not yet defined
>>DETAIL:  Creating a shell type definition.
>>psql:postgis.sql:47: ERROR:  could not load library
>>"/usr/local/pgsql/lib/libpostgis.so.0.9": ld.so.1:
>>/usr/local/pgsql/bin/postmaster: fatal: relocation error:
>>file/usr/local/pgsql/lib/libpostgis.so.0.9: symbol
>>_ZTIN4geos13GEOSExceptionE: referenced symbol not found
>>psql:postgis.sql:52: ERROR:  current transaction is aborted, commands
>>ignored until end of transaction block
>>
>>-----Original Message-----
>>From: postgis-users-bounces at postgis.refractions.net
>>[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
>>Bitner
>>Sent: Tuesday, October 26, 2004 1:43 PM
>>To: PostGIS Users Discussion
>>Subject: RE: [postgis-users] postgis.sql giving error on libgeos
>>
>>
>>libgeos and libperl came from the CSW packages on blastwave.org, as such
>>they are installed in /opt/csw/lib. Gmake appropriately found these
>>libraries while compiling after I added them to the Makefile. I am on
>>Solaris and do not have ldconfig.  I had the path /opt/csw/lib in my
>>LD_LIBRARY_PATH.  After your message I added relavent paths using crle (I
>>believe that is the equivalent to ldconfig for Solaris) and unset the
>>LD_LIBRARY_PATH. Still, the paths are found when doing an ldd on
>>libpostgis.so, but I get the exact same error message when using psql -f
>>postgis.sql -d [mydb].
>>
>>I am really getting nowhere fast so any help is appreciated...
>>
>>-----Original Message-----
>>From: postgis-users-bounces at postgis.refractions.net
>>[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
>>Ramsey
>>Sent: Tuesday, October 26, 2004 1:10 PM
>>To: PostGIS Users Discussion
>>Subject: Re: [postgis-users] postgis.sql giving error on libgeos
>>
>>
>>Is it (libgeos) in /usr/local/lib ? Is /usr/local/lib in your
>>/etc/ld.so.conf file? Have you run /sbin/ldconfig as root?
>>
>>Paul
>>
>>David Bitner wrote:
>>
>>
>>
>>>Alright, I'm getting there bit by bit.  Cpp was out of my path, that
>>
>>solved
>>
>>
>>>that problem.  Now when I run postgis.sql, I get the following error:
>>>
>>>psql:postgis.sql:47: NOTICE:  type "histogram2d" is not yet defined
>>>DETAIL:  Creating a shell type definition.
>>>psql:postgis.sql:47: ERROR:  could not load library
>>>"/usr/local/pgsql/lib/libpostgis.so.0.9": ld.so.1:
>>>/usr/local/pgsql/bin/postmaster: fatal: libgeos.so.2: open failed: No such
>>>file or directory
>>>
>>>When I do an ldd on libpostgis.so.0.9, it finds all the libraries it needs
>>>there.  libgeos.so.2 is located where I designated in the Makefile.
>>>
>>>One of these days, I'll get up and running...
>>>
>>>-----Original Message-----
>>>From: postgis-users-bounces at postgis.refractions.net
>>>[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
>>>Ramsey
>>>Sent: Monday, October 25, 2004 4:06 PM
>>>To: PostGIS Users Discussion
>>>Subject: Re: [postgis-users] Zero Length postgis.sql on Make
>>>
>>>
>>>Check the command that the Makefile is running to generate the .sql file.
>>>Decompose it into bits and run the bits at the command line. One of the
>>
>>bits
>>
>>
>>>is failing you (probably the cpp bit, but one never knows).
>>>
>>>Paul
>>>
>>>Quoting David Bitner <bitner at macnoise.com>:
>>>
>>>
>>>
>>>
>>>>After running into problems with geos_version.sh that I got past with the
>>>>help of strk at refractions, I am now getting a zero length postgis.sql
>>>
>>>file
>>>
>>>
>>>
>>>>with no errors coming from gmake -- other utilities work fine (ie
>>>>shp2pgsql).
>>>>
>>>>I am compiling PostGIS 0.9.0 with Geos 2.0.0 (binary from
>>>
>>>CSW/blastwave.org)
>>>
>>>
>>>
>>>>on Solaris 9 (x86).
>>>>
>>>>Has anyone ever run into this problem before?  Any hints about how to
> 
> fix?
> 
>>>>David
>>>>
>>>>
>>>>_______________________________________________
>>>>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
>>>
>>>
>>>
>>>_______________________________________________
>>>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
>>
>>
>>
>>_______________________________________________
>>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
> 
> 
> _______________________________________________
> 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




More information about the postgis-users mailing list