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

[Rafael Orta]

Hello Everybody
   
  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
   
  psql -d smarter -f lwpostgis.sql and I get the following error 
   
  -bash-3.00$ psql -d smarter -f lwpostgis.sql
BEGIN
psql:lwpostgis.sql:47: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
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
psql:lwpostgis.sql:52: ERROR:  current transaction is aborted, commands ignored until end of transaction block

  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.
   
  Any idea about what could be happening here? My $libdir library points to libdir=/usr/local/pgsql/lib
   
  -bash-3.00$ cd /usr/local/pgsql/lib
-bash-3.00$ ls
ascii_and_mic.so       latin_and_mic.so       libecpg.so.5      libpgtypes.so      pgxs                  utf8_and_euc_kr.so     utf8_and_sjis.so
cyrillic_and_mic.so    libecpg.a              libecpg.so.5.1    libpgtypes.so.2    plpgsql.so            utf8_and_euc_tw.so     utf8_and_uhc.so
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
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
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
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
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
-bash-3.00$

   
  Thanks in advance
   
  Rafael Orta


***************************************************** 
Rafael Orta                                  Phone: (609)-330-3193 
Sr. Oracle DBA                            Fax: (856)-642-7679 
Technical Manager 
Oraprofessionals                          Email: rorta_us at yahoo.com 
******************************************************
 		
---------------------------------
Do you Yahoo!?
 Everyone is raving about the  all-new Yahoo! Mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060928/858c2276/attachment.html>