[postgis-users] Error running lwpostgis.sql - Missing PG_MODULE_MAGIC

Christian Gadge christian.gadge at ufz.de
Fri Jun 27 06:32:17 PDT 2008

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:

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"*/

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.


Christian Gadge

Datenmanagement / 
Department Stadtökologie , Umweltplanung und Verkehr

Helmholtz-Zentrum für Umweltforschung GmbH - UFZ
Permoserstraße 15 I 04318 Leipzig
Telefon +49 (0)341 235-1730
christian.gadge at ufz.de


Das UFZ hat einen neuen Namen: Helmholtz-Zentrum für Umweltforschung GmbH - UFZ

Sitz der Gesellschaft: Leipzig
Registergericht: Amtsgericht Leipzig
Handelsregister Nr. B 4703
Vorsitzender des Aufsichtsrats: MinDirig Hartmut F. Grübel
Wissenschaftlicher Geschäftsführer: Prof. Dr. Georg Teutsch
Administrativer Geschäftsführer: Dr. Andreas Schmidt

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080627/78239ef3/attachment.html>

More information about the postgis-users mailing list