[postgis-users] Problems installing PostGIS on Red Hat EL 5

[Paragon]

Jeshua,

Disregard my last message.  I had a typo in my last line.  It should have
been

 ln -s /usr/lib/libgeos_c.so.3.0.0 /usr/lib/libgeos_c.so.1

After correcting that all seems to be fine so far and I get
"POSTGIS="1.3.3SVN" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.5.0, 22 Oct 2006"
USE_STATS (procs from 1.3.2 need upgrade)"


Now I'm going to cross my fingers, upgrade my db, run the aggregate
regression test.  And hopwfully all will check fine.

Thanks again Jeshua - you are a life saver.

Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon
Sent: Saturday, February 02, 2008 10:49 AM
To: 'Jeshua Lacock'; 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Problems installing PostGIS on Red Hat EL 5

Jeshua,

Thanks again.  Otool doesn't exist on RedHat evidentally, but the equivalent
appears to be ldd

So running
ldd -d  /usr/lib/pgsql/liblwgeom.so | grep libgeos

Gives me

        libgeos_c.so.1 => /usr/lib/libgeos_c.so.1 (0x00519000)
        libgeos.so.2 => /usr/lib/libgeos.so.2 (0x00c71000) undefined symbol:
SPI_tuptable  (/usr/lib/pgsql/liblwgeom.so) undefined symbol:
CurrentMemoryContext  (/usr/lib/pgsql/liblwgeom.so) undefined symbol:
my_exec_path  (/usr/lib/pgsql/liblwgeom.so)
undefined symbol: textout       (/usr/lib/pgsql/liblwgeom.so)
undefined symbol: SPI_processed (/usr/lib/pgsql/liblwgeom.so) undefined
symbol: default_statistics_target
(/usr/lib/pgsql/liblwgeom.so)


On further inspection of what /usr/lib/libgeos.so.2 ls -ahn
/usr/lib/libgeos.so.2 

Gives me
/usr/lib/libgeos.so.2 -> libgeos.so.2.2.3

Ls -ahn /usr/lib/libgeos.so.2 ---> libgeos.so.1.1.1

So I guess that is the root of my problem.  To try to overcome this
predicament - I deleted those symlinks rm /usr/lib/libgeos.so.2 rm
/usr/lib/libgeos_c.so.1

cp /usr/local/lib/liggeos.so /usr/lib/libgeos.so.3.0.0 cp
/usr/local/lib/libgeos_c.so /usr/lib/libgeos_c.so.3.0.0 ln -s
/usr/lib/libgeos.so.3.0.0 /usr/lib/libgeos.so.2 ln -s
/usr/lib/libgeos.so.3.0.0 /usr/lib/libgeos_c.so.1 service postgresql restart

---Well I guess that got a bit warmer - now I am getting this error

ERROR: could not load library "/usr/lib/pgsql/liblwgeom.so":
/usr/lib/pgsql/liblwgeom.so: undefined symbol: GEOSUnion SQL state: 58P01
Context: SQL statement "SELECT postgis_lib_version()"
PL/pgSQL function "postgis_full_version" line 11 at SQL statement

Thanks,
Regina




-----Original Message-----
From: Jeshua Lacock [mailto:jeshua at 3DTOPO.com]
Sent: Wednesday, April 02, 2008 2:52 AM
To: PostGIS Users Discussion; Paragon Corporation
Subject: Re: [postgis-users] Problems installing PostGIS on Red Hat EL 5


On Apr 1, 2008, at 11:39 PM, Paragon Corporation wrote:
> ERROR:  could not load library "/usr/lib/pgsql/liblwgeom.so":
> /usr/lib/pgsql/liblwgeom.so: undefined symbol:  
> GEOSTopologyPreserveSimplify
> CONTEXT:  SQL statement "SELECT postgis_lib_version()"
> PL/pgSQL function "postgis_full_version" line 11 at SQL statement

On Apr 2, 2008, at 12:28 AM, Paragon Corporation wrote:

> ./configure --with-pgsql=/usr/bin/pg_config  --with-geos= 
> /usr/local/bin/geos-config



Run 'otool -L' on liblwgeom to see if it is linked to geos:

	otool -L /usr/lib/pgsql/liblwgeom.so | grep libgeos

You should see a line with (Or something similar):

	/usr/local/lib/libgeos_c.1.so (compatibility version 6.0.0, current
version 6.1.0)

If you don't see it needs to be linked to it.

P.S. I am on Mac OS X, so I am not sure if RedHat has otool, but I think it
does...


Yours,

Jeshua Lacock
Founder/Programmer
3DTOPO Incorporated
<http://3DTOPO.com>
Phone: 877.240.1364



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users