RPostgreSQL installation error - RPostgreSQL.so: undefined symbol: PQpass

Question

I try to install the RPostgreSQL R-package, but I get 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 installed libpqand postgresql-dev. All 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 Version R - 3.0.2 Operating System -CentOS-6.4

I’m missing some little things, but I can’t find out why this is happening.

What am I doing wrong? How to fix this?

Thank:)

Answer 1

The RPostgreSQL package only checks PostgreSQL libraries 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

LD_LIBRARY_PATH, /etc/ld.so.conf.

, RPostgreSQL , PostgreSQL .

/usr/lib64/pgsql /usr/lib/pgsql . .:)

Answer 2

, pgsql . :

ln -s /usr/pgsql-9.3/lib /usr/lib/pgsql

ln -s /usr/pgsql-9.3/include /usr/include/pgsql

:)