[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