<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Mark and Paul,<br>
<br>
thanks for your suggestion. Since my database was not really big by now
I picked the easier solution to just star a new database. And now I'm
really pleased to mention that is it working correctly!<br>
<br>
#select postgis_full_version();<br>
postgis_full_version<br>
-------------------------------------------------------------------------------------<br>
POSTGIS="1.2.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct
2006" USE_STATS<br>
(1 row)<br>
<br>
<br>
Thanks a lot for your support<br>
<br>
Regards,<br>
<br>
Marc<br>
<br>
<br>
Mark Cave-Ayland wrote:
<blockquote cite="mid:1185486817.29455.8.camel@mca-desktop" type="cite">
<pre wrap="">On Thu, 2007-07-26 at 22:33 +0100, Mark Cave-Ayland wrote:
</pre>
<blockquote type="cite">
<pre wrap="">So the version of PostgreSQL being used has been installed
under /data/ulysse/postgis_geos/postgresql-8.2.4 - if you want to
override this then you need to re-run configure with the --with-pgsql
option pointing to the correct pg_config for the installation you want
to use.
</pre>
</blockquote>
<pre wrap=""><!---->
Actually ignore that - the path is likely correct, but I didn't notice
the missing postgis_geos directory in your first path :(
Unfortunately the paths to liblwgeom.so are embedded within the SQL
function definitions in your database, so you need to reload the
lwpostgis.sql functions in order to pick up the new path. That's not too
easy with PostGIS at the moment, but you should find that things will
work if you create a new database and load in the PostGIS functions from
your new installation e.g:
createdb newdb
psql -d newdb
-f /data/ulysse/postgis_geos/postgresql-8.2.4/share/postgresql/contrib/lwpostgis.sql
If you connect to newdb, does the output of "SELECT
postgis_full_version()" look correct now?
Kind regards,
Mark.
</pre>
</blockquote>
<br>
</body>
</html>