[R] ERROR: compilation failed for package 'RdbiPgSQL'

From: Srinivas Iyyer <srini_iyyer_bio_at_yahoo.com>
Date: Fri 03 Feb 2006 - 18:38:27 EST


Dear Group,
 I have been trying to connect postgres with R. I followed the instructions from :
http://grass.itc.it/statsgrass/r_and_dbms.html.

However, RdbiPgSQL fails to install and throws up error.

Could any one please help me where the things are going wrong.

I have attached the log, and the necessary files for postgresql stuff.

Sorry for long message. Looking forward for some help please.

thanks
sri

>install.packages(contriburl="http://www.bioconductor.org/repository/devel/package/Source/",
"Rdbi")

**snip***
** building package indices ...
* DONE (Rdbi)

>

install.packages(contriburl="http://www.bioconductor.org/repository/devel/package/Source/", "RdbiPgSQL")
trying URL
'http://www.bioconductor.org/repository/devel/package/Source//RdbiPgSQL_1.5.1.tar.gz' Content type 'application/x-gzip' length 28297 bytes opened URL



downloaded 27Kb

The downloaded packages are in

        /tmp/RtmpR27533/downloaded_packages Warning message:
installation of package 'RdbiPgSQL' had non-zero exit status in: install.packages(contriburl = "http://www.bioconductor.org/repository/devel/package/Source/",

-->
 /var/lib/pgsql/
backups data initdb.i18n

-->
/usr/bin/psql
-->
/usr/bin/postgres

-->
/usr/share/pgsql/

contrib                 pg_hba.conf.sample     
postgres.bki            sql_features.txt
conversion_create.sql pg_ident.conf.sample postgres.description unknown.pltcl
information_schema.sql pg_service.conf.sample postgresql.conf.sample
-->
psql lib files:
/usr/lib64/pgsql
ascii_and_mic.so     euc_kr_and_mic.so      ltree.so  
     refint.so          utf8_and_big5.so      
utf8_and_sjis.so
autoinc.so           euc_tw_and_big5.so    
misc_utils.so   rserv.so          
utf8_and_cyrillic.so   utf8_and_tcvn.so
btree_gist.so        fti.so                
moddatetime.so  rtree_gist.so      utf8_and_euc_cn.so 
   utf8_and_uhc.so
chkpass.so           fuzzystrmatch.so       noup.so   
     seg.so             utf8_and_euc_jp.so    
utf8_and_win1250.so
cube.so              insert_username.so     pending.so
     string_io.so       utf8_and_euc_kr.so    
utf8_and_win1256.so
cyrillic_and_mic.so  int_aggregate.so      
pgcrypto.so     tablefunc.so       utf8_and_euc_tw.so 
   utf8_and_win874.so
dblink.so            _int.so               
pgstattuple.so  timetravel.so      utf8_and_gb18030.so
dbsize.so            isbn_issn.so           plperl.so 
     tsearch2.so        utf8_and_gbk.so
earthdistance.so     latin2_and_win1250.so  plpgsql.so
     tsearch.so         utf8_and_iso8859_1.so
euc_cn_and_mic.so    latin_and_mic.so      
plpython.so     user_locks.so      utf8_and_iso8859.so
euc_jp_and_sjis.so   lo.so                  pltcl.so  
     utf8_and_ascii.so  utf8_and_johab.so





/usr/lib/libodbcpsql.so
/usr/lib/libodbcpsql.so.2
/usr/lib/libodbcpsql.so.1.0.0
/usr/lib/libodbcpsql.so.1
/usr/lib/libodbcpsql.so.2.0.0
/usr/lib64/libodbcpsql.so
/usr/lib64/libodbcpsql.so.2
/usr/lib64/libodbcpsql.so.1.0.0

/usr/lib64/libodbcpsql.so.1
/usr/lib64/libodbcpsql.so.2.0.0

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Feb 03 18:47:25 2006

This archive was generated by hypermail 2.1.8 : Fri 03 Feb 2006 - 20:29:52 EST