RPostgreSQL installation Error - RPostgreSQL.so: undefined symbol: PQpass
Hi All,
Thank you for your responses. It really helped. :)
The package RPostgreSQL checks for PostgreSQL libraries only in the
following directory paths,
/usr/lib /usr/lib/pgsql /usr/lib/postgresql /usr/local/lib
/usr/local/lib/pgsql /usr/local/lib/postgresql /usr/local/pgsql/lib
/usr/local/postgresql/lib /opt/lib /opt/lib/pgsql /opt/lib/postgresql
/opt/local/lib /opt/local/lib/postgresql /opt/local/lib/postgresql84
/sw/opt/postgresql-8.4/lib /Library/PostgresPlus/8.4SS/lib /sw/lib
It does not check for the directories either in LD_LIBRARY_PATH or in
/etc/ld.so.conf.
So RPostgreSQL installation will be successful only if the PostgreSQL
libraries exist in any of the above directories.
When I copied the libraries from /usr/lib64/pgsql to /usr/lib/pgsql and
tried installing the package. It worked. :)
Regards,
Manoj G
On Fri, May 23, 2014 at 6:48 PM, NISHIYAMA Tomoaki <
tomoakin at staff.kanazawa-u.ac.jp> wrote:
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 at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
-- Brian D. Ripley, ripley at 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