[DebianGIS] error postgis -> could not load library "/opt/pgsql/lib/postgis-1.5.so"
Hello to all ...
I compiled postgresql 8.4.4
wget http://wwwmaster.postgresql.org/redir/198/h/source/v8.4.4/postgresql-8.4.4.tar.bz2
cd postgresql-8.4.4
tar jxf postgresql-8.4.4.tar.bz2
./configure --prefix=/opt/pgsql --with-pgport=5800
make
sudo make install
sudo mkdir /opt/pgsql/data
sudo chown -R pgsql /opt/pgsql/data
sudo su - pgsql
/opt/pgsql/bin/initdb -D /opt/pgsql/data
/opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l logfile start
/opt/pgsql/bin/createdb mapas
/opt/pgsql/bin/psql mapas
postgis 1.5
cd /opt
sudo wget http://postgis.refractions.net/download/postgis-1.5.1.tar.gz
sudo tar zxf postgis-1.5.1.tar.gz
cd postgis-1.5.1
./configure --prefix=/opt/postgis --with-pgconfig=/opt/pgsql/bin/pg_config --with-projdir=/opt/proj --with-geosconfig=/opt/geos/bin/geos-config --with-gui
make
make install
ldconfig
/sbin/ldconfig /usr/local/pgsql/lib
error:
/opt/pgsql/bin/createdb mapas
/opt/pgsql/bin/createlang plpgsql mapas
/opt/pgsql/bin/psql -f /opt/pgsql/share/contrib/postgis-1.5/postgis.sql mapas
WARNING: nonstandard use of \\ in a string literal at character 263
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
FATAL: database "pgsql" does not exist
FATAL: database "maas" does not exist
ERROR: could not load library "/opt/pgsql/lib/postgis-1.5.so": /opt/pgsql/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance
STATEMENT: CREATE OR REPLACE FUNCTION st_spheroid_in(cstring)
RETURNS spheroid
AS '$libdir/postgis-1.5','ellipsoid_in'
LANGUAGE 'C' IMMUTABLE STRICT;
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: CREATE OR REPLACE FUNCTION st_spheroid_out(spheroid)
RETURNS cstring
it has a solution?
ERROR:
Could not load library "/ opt/pgsql/lib/postgis-1.5.so": /
opt/pgsql/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance
not load? undefined symbol?
Reply to: