Hi, Because Manoj G wrote:
>>> ERROR: loading failed >>> >>> * removing ‘/usr/lib64/R/library/RPostgreSQL’ there may be no /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so left there. $ svn checkout http://rpostgresql.googlecode.com/svn/trunk/ rpostgresql-read-only $ cd rpostgresql-read-only $ R CMD INSTALL RPostgreSQL $ R CMD ldd RPostgreSQL/src/RPostgreSQL.so or $ tar zxvf RPostgreSQL_0.4.tar.gz $ R CMD INSTALL RPostgreSQL $ R CMD ldd RPostgreSQL/src/RPostgreSQL.so would be necessary to investigate which library is used. In addition, I would see whether psql works fine, response of $ pg_config and $ ldd `which psql` best regards. Tomoaki On 2014/05/23, at 20:32, Prof Brian Ripley wrote: > On 23/05/2014 10:41, NISHIYAMA Tomoaki wrote: >> Hi, >> >>> All the library files are in the directory >>> /usr/lib64/pgsql/ >> >> >> Is this directory specified in LD_LIBRARY_PATH or /etc/ld.so.conf? > > That is not the message I would expect if the library was not being > found. Try > > R CMD ldd /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so > > to see which library is being found. > >> >> >> >> On 2014/05/23, at 18:16, Manoj G wrote: >> >>> Hi, >>> >>> I am trying to install R-Package RPostgreSQL, but getting the following >>> error, >>> >>> Error in dyn.load(file, DLLpath = DLLpath, ...) : >>> >>> unable to load shared object >>> '/usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so': >>> >>> /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so: undefined symbol: >>> PQpass >>> >>> Error: loading failed >>> >>> Execution halted >>> >>> ERROR: loading failed >>> >>> * removing ‘/usr/lib64/R/library/RPostgreSQL’ >>> >>> I have libpq and postgresql-dev installed. All the library files are in the >>> directory >>> >>> /usr/lib64/pgsql/ and all header files are in the directory >>> >>> /usr/include/pgsql/ >>> >>> Postgre Version - 9.3.4 R Version - 3.0.2 Operating System - CentOS-6.4 >>> >>> I am missing some small thing, but unable to find out why this is happening. >>> >>> What am I doing wrong? How to correct this? >>> >>> >>> >>> Thanks and Regards, >>> >>> Manoj G >>> >>> [[alternative HTML version deleted]] >>> >>> _______________________________________________ >>> R-sig-DB mailing list -- R Special Interest Group >>> R-sig-DB@r-project.org >>> https://stat.ethz.ch/mailman/listinfo/r-sig-db >> >> _______________________________________________ >> R-sig-DB mailing list -- R Special Interest Group >> R-sig-DB@r-project.org >> https://stat.ethz.ch/mailman/listinfo/r-sig-db >> > > > -- > Brian D. Ripley, rip...@stats.ox.ac.uk > Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ > University of Oxford, Tel: +44 1865 272861 (self) > 1 South Parks Road, +44 1865 272866 (PA) > Oxford OX1 3TG, UK Fax: +44 1865 272595 _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
