Thanks Mark, that was one issue. However, I discovered that the actual problems arose from 32 and 64 bit binaries and libs being mixed up. The PostgreSQL installation from CSW had the 64 bit files. The Proj4 from CSW, however, only had the 32bit versions of things. Thus, I had to compile both GEOS and Proj4 from source. I had to fiddle around with LDFLAGS settings etc. to make gcc pick up the 64bit shared system libraries. When compiling PostGIS, the Makefile in the lwgeom subdirectory still wouldn't pick up the -m64 flag, so I added it manually. Everything was fine then. :-)
Cheers, Alex Dr Alexander von Luenen Senior Research Associate Great Britain Historical GIS Dept. of Geography University of Portsmouth Buckingham Building, Lion Terrace Portsmouth, PO1 3HE, UK tel: +44-(0)23-9284-2500 fax: +44-(0)23-9284-2512 >>> Mark Cave-Ayland <[email protected]> 20/05/2009 10:14 >>> Alexander Von Luenen wrote: > Hi, > > unfortunately, I encountered the next problem. When running > > psql -d vob -U postgres -f lwpostgis.sql > > I get the error > > ERROR: could not access file "$libdir/liblwgeom": No such file or directory > > pg_config --pkglibdir returns '/opt/csw/postgresql/lib', liblwgeom.so.* is in > there. > > Running 'ldd /opt/csw/postgresql/lib/liblwgeom.so' returns > > libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 > libproj.so.0 => /opt/csw/lib/libproj.so.0 > libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1 > libgeos-3.1.0.so => /usr/local/lib/libgeos-3.1.0.so > libstdc++.so.6 => /usr/sfw/lib/libstdc++.so.6 > libm.so.2 => /lib/libm.so.2 > libm.so.1 => /lib/libm.so.1 > libc.so.1 => /lib/libc.so.1 > /platform/SUNW,T5440/lib/libc_psr.so.1 > > Is there something I am missing? Different versions? I have PostgreSQL 8.3.1 > installed from CSW, and have compiled PostGIS 1.3.6 w/ Proj4 4.4.8 (from CSW) > and GEOS 3.1.0 (compiled from source). > > TIA, > Alex Hi Alex, As you have quite rightly determined, if the file is present then this error normally indicates that one of the dependent libraries is missing. Note that you need to make sure that all of the dependent libraries are visible by the user that runs the PostgreSQL server; setting LD_LIBRARY_PATH in a console and using ldd will not make the libraries visible to you but not to the database server. 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
