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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users