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

[Paragon]

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