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

Paul Ramsey pramsey at cleverelephant.ca
Wed Apr 2 08:42:18 PDT 2008


In addition to adding GEOS 3, you need to complete REMOVE GEOS 2.2.
Are you sure your system is clean? I'm pretty sure I scraped this
version-dependent stuff out of postgis-svn a couple days ago, so all I
can think of is that you successfully built against the new version of
GEOS but your system is still trying to link against the old version
of GEOS.

P

On Sat, Feb 2, 2008 at 8:49 AM, Paragon <lr at pcorp.us> wrote:
> 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
>



More information about the postgis-users mailing list