[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Error running lwpostgis.sql - Missing
From:       Christian Gadge <christian.gadge () ufz ! de>
Date:       2008-06-27 13:32:17
Message-ID: fbecc36c4255.48650801 () ufz ! de
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hello List=2C

I=27ve some problems during install postgis1=2E3=2E3 on Ubuntu-6=2E06-Se=
rver with PostgreSQL-8=2E2=2E7=2E
When I try to run the lwpostgis=2Esql I get the following massage=3A

BEGIN
psql=3A/usr/local/pgsql/share/lwpostgis=2Esql=3A45=3A NOTICE=3A  type =22=
histogram2d=22
is not yet defined
DETAIL=3A  Creating a shell type definition=2E
psql=3A/usr/local/pgsql/share/lwpostgis=2Esql=3A45=3A ERROR=3A  incompat=
ible library
=22/usr/local/pgsql/lib/liblwgeom=2Eso=22=3A missing magic block
HINT=3A  Extension libraries are required to use the PG=5FMODULE=5FMAGIC=
 macro=2E
Searching the mailing list I found many topics with the same problem=2E =
Some guys advised to insert the following lines in one (=3F!) modul=3A
/*=23include =22pgmagic=2Eh=22*/
=23ifdef PG=5FMODULE=5FMAGIC
PG=5FMODULE=5FMAGIC=3B
=23endif

So I checked the lwgeom=5Fpg=2Ec in the contrib dir of PostgreSQL /postg=
resql-8=2E2=2E7/cpntrib/postgres-1=2E3=2E3/lwgeom
and these lines are allready written there=2E

What should I do / check next=3F Did I made any mistakes by installing P=
ostgreSQL and PostGIS via selfcompiling and installing=3F
Before I installed these versions=2C PostgreSQL-8=2E1 was installed via =
apt-get and removed=2E

Thanks for any help=2E
Cheers=2C

Christian

++++++++++++++++++++++++++++++++++++++++++++++
Christian Gadge

Datenmanagement / =

Department Stadt=F6kologie =2C Umweltplanung und Verkehr

Helmholtz-Zentrum f=FCr Umweltforschung GmbH - UFZ
Permoserstra=DFe 15 I 04318 Leipzig
Telefon +49 (0)341 235-1730
christian=2Egadge=40ufz=2Ede

http=3A//www=2Eufz=2Ede

Das UFZ hat einen neuen Namen=3A Helmholtz-Zentrum f=FCr Umweltforschung=
 GmbH - UFZ

Sitz der Gesellschaft=3A Leipzig
Registergericht=3A Amtsgericht Leipzig
Handelsregister Nr=2E B 4703
Vorsitzender des Aufsichtsrats=3A MinDirig Hartmut F=2E Gr=FCbel
Wissenschaftlicher Gesch=E4ftsf=FChrer=3A Prof=2E Dr=2E Georg Teutsch
Administrativer Gesch=E4ftsf=FChrer=3A Dr=2E Andreas Schmidt
++++++++++++++++++++++++++++++++++++++++++++++



[Attachment #5 (text/html)]

Hello List,<br><br>I've some problems during install postgis1.3.3 on =
Ubuntu-6.06-Server with PostgreSQL-8.2.7.<br>When I try to run the lw=
postgis.sql I get the following massage:<br><br><pre>BEGIN<br>psql:/u=
sr/local/pgsql/share/lwpostgis.sql:45: NOTICE:  type "histogram2d"<br=
>is not yet defined<br>DETAIL:  Creating a shell type definition.<br>=
psql:/usr/local/pgsql/share/lwpostgis.sql:45: ERROR:  incompatible li=
brary<br>"/usr/local/pgsql/lib/liblwgeom.so": missing magic block<br>=
HINT:  Extension libraries are required to use the PG_MODULE_MAGIC ma=
cro.</pre><br>Searching the mailing list I found many topics with the=
 same problem. Some guys advised to insert the following lines in one=
 (?!) modul:<br><pre>/*#include "pgmagic.h"*/<br>#ifdef PG_MODULE_MAG=
IC<br>PG_MODULE_MAGIC;<br>#endif<br><br>So I checked the lwgeom_pg.c =
in the contrib dir of PostgreSQL /postgresql-8.2.7/cpntrib/postgres-1=
.3.3/lwgeom<br>and these lines are allready written there.<br><br>Wha=
t should I do / check next? Did I made any mistakes by installing Pos=
tgreSQL and PostGIS via selfcompiling and installing?<br>Before I ins=
talled these versions, PostgreSQL-8.1 was installed via apt-get and r=
emoved.<br></pre><br>Thanks for any help.<br>Cheers,<br><br>Christian=
<br><br>++++++++++++++++++++++++++++++++++++++++++++++<br>Christian G=
adge<br><br>Datenmanagement / <br>Department Stadt=F6kologie , Umwelt=
planung und Verkehr<br><br>Helmholtz-Zentrum f=FCr Umweltforschung Gm=
bH - UFZ<br>Permoserstra=DFe 15 I 04318 Leipzig<br>Telefon +49 (0)341=
 235-1730<br>christian.gadge@ufz.de<br><br>http://www.ufz.de<br><br>D=
as UFZ hat einen neuen Namen: Helmholtz-Zentrum f=FCr Umweltforschung=
 GmbH - UFZ<br><br>Sitz der Gesellschaft: Leipzig<br>Registergericht:=
 Amtsgericht Leipzig<br>Handelsregister Nr. B 4703<br>Vorsitzender de=
s Aufsichtsrats: MinDirig Hartmut F. Gr=FCbel<br>Wissenschaftlicher G=
esch=E4ftsf=FChrer: Prof. Dr. Georg Teutsch<br>Administrativer Gesch=
=E4ftsf=FChrer: Dr. Andreas Schmidt<br>++++++++++++++++++++++++++++++=
++++++++++++++++<br>


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]