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

[Rafael Orta]

Thank you, that helped I copied the gis librarys to the place where the script was looking them
for and re-run the script, it seems to be working now. Thanks a lot :-) 

cd /spatial/Postgis/Geos/geos-3.0.0rc1/capi/.libs
[root at spatial .libs]# cp * /usr/local/pgsql/lib/.
[root at spatial .libs]# ls -las /usr/local/pgsql/lib/libgeos_c.so.1

Sometimes you just need someone to tell you the abvious things because by nature you just think that it is way more complex.

Thanks again

Rafael Orta
----- Original Message ----
From: Uwe Seher <useher at web.de>
To: rorta_us at yahoo.com; PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Friday, September 29, 2006 2:59:20 AM
Subject: AW: [postgis-users] -- Error running lwpostgis.sql --



 



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 
  Yahoo! Mail.

____________
Virus checked by G DATA AntiVirusKit





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061001/6ce92bfb/attachment.html>