Christian Gadge wrote:
Hello List,
I've some problems during install postgis1.3.3 on Ubuntu-6.06-Server with
PostgreSQL-8.2.7.
When I try to run the lwpostgis.sql I get the following massage:
BEGIN
psql:/usr/local/pgsql/share/lwpostgis.sql:45: NOTICE: type "histogram2d"
is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/local/pgsql/share/lwpostgis.sql:45: ERROR: incompatible library
"/usr/local/pgsql/lib/liblwgeom.so": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
Searching the mailing list I found many topics with the same problem. Some guys
advised to insert the following lines in one (?!) modul:
/*#include "pgmagic.h"*/
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
So I checked the lwgeom_pg.c in the contrib dir of PostgreSQL
/postgresql-8.2.7/cpntrib/postgres-1.3.3/lwgeom
and these lines are allready written there.
What should I do / check next? Did I made any mistakes by installing PostgreSQL
and PostGIS via selfcompiling and installing?
Before I installed these versions, PostgreSQL-8.1 was installed via apt-get and
removed.
Thanks for any help.
Cheers,
Christian
Hi Christian,
PG_MODULE_MAGIC was only included from PostgreSQL 8.2 upwards, so it
sounds as if the PostGIS configure script picked up the older PostgreSQL
version instead. You should do a "make clean" in your PostGIS source
directory, and then re-run configure with an additional
"--with-pgsql=/usr/local/pgsql/bin/pg_config" argument to force it to
pick up the newer installation. Follow this with "make install" and you
should then be good to go.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
