[postgis-users] Postgis 1.3.7 wit PostgreSQL 8.4. (64bit) on OpenSolaris

[Mark Cave-Ayland]

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