<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006>Hi!</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff 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 face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006>Hope this was helpful.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006>bye</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006>Uwe Seher</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=648595406-29092006> </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><FONT
size=2></FONT><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<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>
<HR SIZE=1>
Do you Yahoo!?<BR>Everyone is raving about the <A
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></BODY></HTML>