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

[Uwe Seher]

Hi!
 
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 ;))
 
Hope this was helpful.
 
bye
Uwe Seher
 
 



  _____  

Von: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Rafael
Orta
Gesendet: Freitag, 29. September 2006 05:37
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] -- Error running lwpostgis.sql --


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
<http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/mailb
eta> Yahoo! Mail.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060929/57db12e9/attachment.html>