<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt">Thank you, that helped I copied the gis librarys to the place where the script was looking them<br>for and re-run the script, it seems to be working now. Thanks a lot :-) <br><br>cd /spatial/Postgis/Geos/geos-3.0.0rc1/capi/.libs<br>[root@spatial .libs]# cp * /usr/local/pgsql/lib/.<br>[root@spatial .libs]# ls -las /usr/local/pgsql/lib/libgeos_c.so.1<br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br>Sometimes you just need someone to tell you the abvious things because by nature you just think that it is way more complex.<br><br>Thanks again<br><br>Rafael Orta<br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Uwe Seher <useher@web.de><br>To: rorta_us@yahoo.com; PostGIS Users Discussion
<postgis-users@postgis.refractions.net><br>Sent: Friday, September 29, 2006 2:59:20 AM<br>Subject: AW: [postgis-users] -- Error running lwpostgis.sql --<br><br>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006">Hi!</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006">You can try 'ldconfig' to reread all installed
libraries. Another way which was a solution sometimes, is to execute the
sql from the origin directory. Or you can exchange the variable $libdir in the
sql with the absolut path to liblwgeom.so.1 (on your own risk
;))</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006">Hope this was helpful.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006">bye</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006">Uwe Seher</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span class="648595406-29092006"> </span></font></div>
<div><font color="#0000ff" face="Arial" size="2"></font> </div><font size="2"></font><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div class="OutlookMessageHeader" dir="ltr" align="left" lang="de">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>Von:</b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>Im Auftrag von
</b>Rafael Orta<br><b>Gesendet:</b> Freitag, 29. September 2006
05:37<br><b>An:</b> postgis-users@postgis.refractions.net<br><b>Betreff:</b>
[postgis-users] -- Error running lwpostgis.sql --<br></font><br></div>
<div></div>
<div>Hello Everybody</div>
<div> </div>
<div>I am new to install Postgis and I will appreciate your help, Installing
Postgis on Red Hat EE 4 I did the make and make install (as root) and I
do not see any errors , then I ran</div>
<div> </div>
<div>psql -d smarter -f lwpostgis.sql and I get the following error </div>
<div> </div>
<div>-bash-3.00$ psql -d smarter -f
lwpostgis.sql<br>BEGIN<br>psql:lwpostgis.sql:47: NOTICE: type
"histogram2d" is not yet defined<br>DETAIL: Creating a shell type
definition.<br>psql:lwpostgis.sql:47: ERROR: could not load library
"/usr/local/pgsql/lib/liblwgeom.so.1.1": libgeos_c.so.1: cannot open shared
object file: No such file or directory<br>psql:lwpostgis.sql:52: ERROR:
current transaction is aborted, commands ignored until end of transaction
block<br></div>
<div>I am not sure I installed the GEOS library (I don;t think I did at least
it comes as part of the POSTGIS rpm) and I am not sure how to install it
either but the POSTGIS Installation manual says that is it recommended which
makes me think it is optional.</div>
<div> </div>
<div>Any idea about what could be happening here? My $libdir library points to
libdir=/usr/local/pgsql/lib</div>
<div> </div>
<div>-bash-3.00$ cd /usr/local/pgsql/lib<br>-bash-3.00$
ls<br>ascii_and_mic.so
latin_and_mic.so
libecpg.so.5
libpgtypes.so
pgxs
utf8_and_euc_kr.so
utf8_and_sjis.so<br>cyrillic_and_mic.so
libecpg.a
libecpg.so.5.1 libpgtypes.so.2
plpgsql.so
utf8_and_euc_tw.so
utf8_and_uhc.so<br>euc_cn_and_mic.so
libecpg_compat.a
liblwgeom.so libpgtypes.so.2.1
utf8_and_ascii.so
utf8_and_gb18030.so
utf8_and_win1250.so<br>euc_jp_and_sjis.so
libecpg_compat.so
liblwgeom.so.1
libpq.a
utf8_and_big5.so
utf8_and_gbk.so
utf8_and_win1252.so<br>euc_kr_and_mic.so
libecpg_compat.so.2 liblwgeom.so.1.1
libpq.so
utf8_and_cyrillic.so utf8_and_iso8859_1.so
utf8_and_win1256.so<br>euc_tw_and_big5.so
libecpg_compat.so.2.1 libpgport.a
libpq.so.4
utf8_and_euc_cn.so utf8_and_iso8859.so
utf8_and_win1258.so<br>latin2_and_win1250.so
libecpg.so
libpgtypes.a
libpq.so.4.1
utf8_and_euc_jp.so
utf8_and_johab.so
utf8_and_win874.so<br>-bash-3.00$<br></div>
<div> </div>
<div>Thanks in advance</div>
<div> </div>
<div>Rafael
Orta</div><br><br>*****************************************************
<br>Rafael Orta Phone: (609)-330-3193 <br>Sr. Oracle DBA Fax: (856)-642-7679
<br>Technical Manager <br>Oraprofessionals Email: rorta_us@yahoo.com
<br>******************************************************
<p>
</p><hr size="1">
Do you Yahoo!?<br>Everyone is raving about the <a rel="nofollow" target="_blank" href="http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/mailbeta">all-new
Yahoo! Mail.</a></blockquote><br><br>____________<br>Virus checked by G DATA AntiVirusKit<br></div><br></div></div><br></body></html>