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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
