[postgis-users] Warning GEOS is NOT enabled

[Mark Cave-Ayland]

On Thu, 2007-07-26 at 22:33 +0100, Mark Cave-Ayland wrote:

> 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.

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.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk