[postgis-users] Warning GEOS is NOT enabled

Paul Ramsey pramsey at refractions.net
Thu Jul 26 16:12:25 PDT 2007


Or, you can update the directory path for the functions in pg_proc. I've 
done that in the past to good effect.

P

Mark Cave-Ayland wrote:
> 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.
> 


-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632



More information about the postgis-users mailing list