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