[R] RPostgreSQL Loading Issues

Rich Shepard rshepard at appl-ecosys.com
Tue Aug 30 19:53:35 CEST 2011


   I'm starting to seriously use R and have tried to solve this issue using
my reference books but I'm missing something simple. Running R-2.13.1 on
Slackware-13.1.

   Trying to invoke RPostgreSQL so I can copy data from a postgres table to
an R data-frame. I installed RPostgreSQL and the library() command shows
it's present:

Packages in library
'/home/rshepard/R/i486-slackware-linux-gnu-library/2.13':

DBI                     R Database Interface
RPostgreSQL             R interface to the PostgreSQL database system

   Yet, trying to load it fails:

> library(RPostgreSQL)
Loading required package: DBI
Error in dyn.load(file, DLLpath = DLLpath, ...) :
   unable to load shared object
'/home/rshepard/R/i486-slackware-linux-gnu-library/2.13/RPostgreSQL/libs/RPostgreSQL.so':
   libR.so: cannot open shared object file: No such file or directory
Error: package/namespace load failed for 'RPostgreSQL'

   The shared library, of course, is present:

[rshepard at salmo ~/R/i486-slackware-linux-gnu-library/2.13/RPostgreSQL/libs]$ ll
-rwxr-xr-x 1 rshepard users 44385 2011-08-03 20:13 RPostgreSQL.so*

   Can someone explain to me what's going on and how I fix it?

Rich



More information about the R-help mailing list