Andreas Luka wrote:

I compiled and installed geos-3.2.0 and proj-4.7.0 successfully with the following options

CFLAGS="-m64" CPPFLAGS="-m64" CXXFLAGS="-m64" LDFLAGS="-m64" FFLAGS="-m64" LDFLAGS="-L/usr/sfw/lib/amd64/" ./configure

make, make install, make check are also okay, files are installed in /usr/local

ls /usr/local -al
drwxr-xr-x  2 root root        16 2010-02-24 00:43 .
drwxr-xr-x  6 root other        6 2010-02-24 00:35 ..
-rw-r--r--  1 root root    296214 2010-02-24 00:35 libgeos_c.a
-rwxr-xr-x+ 1 root root      1020 2010-02-24 00:35 libgeos_c.la
lrwxrwxrwx 1 root root 18 2010-02-24 00:35 libgeos_c.so -> libgeos_c.so.1.6.0 lrwxrwxrwx 1 root root 18 2010-02-24 00:35 libgeos_c.so.1 -> libgeos_c.so.1.6.0
-rwxr-xr-x+ 1 root root    215312 2010-02-24 00:35 libgeos_c.so.1.6.0
-rwxr-xr-x+ 1 root root   4777808 2010-02-24 00:35 libgeos-3.2.0.so
-rw-r--r--  1 root root  13625096 2010-02-24 00:35 libgeos.a
-rwxr-xr-x+ 1 root root       988 2010-02-24 00:35 libgeos.la
lrwxrwxrwx 1 root root 16 2010-02-24 00:35 libgeos.so -> libgeos-3.2.0.so
-rw-r--r--  1 root root    751590 2010-02-24 00:43 libproj.a
-rwxr-xr-x+ 1 root root       841 2010-02-24 00:43 libproj.la
lrwxrwxrwx 1 root root 16 2010-02-24 00:43 libproj.so -> libproj.so.0.6.6 lrwxrwxrwx 1 root root 16 2010-02-24 00:43 libproj.so.0 -> libproj.so.0.6.6
-rwxr-xr-x+ 1 root root    440672 2010-02-24 00:43 libproj.so.0.6.6

I compiled postgis with the following options
CC="gcc -m64" CXX="g++" FFLAGS="-m64" LDFLAGS="-L/usr/sfw/lib/amd64/" ./configure --with-pgsql='/usr/postgres/8.4/bin/amd64/pg_config' --with-geos='/usr/local/bin/geos-config' --with-proj='/usr/local' --with-proj-libdir='/usr/local/lib'

make and make install are okay

ls -al /usr/postgres/8.4/lib/amd64/liblwgeo*
lrwxrwxrwx 1 root root 16 2010-02-24 00:45 /usr/postgres/8.4/lib/amd64/liblwgeom.so -> liblwgeom.so.1.3 lrwxrwxrwx 1 root root 16 2010-02-24 00:45 /usr/postgres/8.4/lib/amd64/liblwgeom.so.1 -> liblwgeom.so.1.3 -rwxr-xr-x 1 root root 980520 2010-02-24 00:45 /usr/postgres/8.4/lib/amd64/liblwgeom.so.1.3

echo $LD_LIBRARY_PATH
/usr/local/lib

seems okay, restart of the database
but I still getting the following error when I run the sql query for lwpostgis.sql:


HINWEIS:  Typ »histogram2d« ist noch nicht definiert
DETAIL:  Hüllentypdefinition wird erzeugt.
FEHLER: konnte Bibliothek »/usr/postgres/8.4/lib/amd64/liblwgeom.so« nicht laden: ld.so.1: postgres: fatal: libgeos_c.so.1: open failed: No such file or directory

********** Fehler **********

FEHLER: konnte Bibliothek »/usr/postgres/8.4/lib/amd64/liblwgeom.so« nicht laden: ld.so.1: postgres: fatal: libgeos_c.so.1: open failed: No such file or directory
SQL Status:58P01

Any suggestion?

How are you starting PostgreSQL? Bear in mind you need to make sure that LD_LIBRARY_PATH is being set for the postgres user as you start the database, and not just the user you are logged in as. You may need to alter the /etc/init.d/postgresql script in order to do this.


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to