[R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7

From: João Gonçalves <joaofgo_at_gmail.com>
Date: Tue, 29 Jun 2010 23:35:44 +0100

Dear list users,

The problem occurs when library(RPostgreSQL) is issued on R. This issue has previously appeared on R mailing list without any robust solution. The error message issued by R:

Loading required package: RPostgreSQL
Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :

   unable to load shared library

   LoadLibrary failure: Unable to locate the specified module. Error: package 'RPostgreSQL' could not be loaded

At the same time an error box appears saying that a given DLL does not exists which makes RPostgreSQL loading to fail. The message appears for any of the following DLLs (that actually exist on X:/PostgreSQL_installation_directory/bin):


To "solve" this problem the actual DLLs from the PostgreSQL installation directory must be copied into the X:/WINDOWS/System32 shared libraries folder in order to make the package operational. Is there a way to solve this from the package internals without having to copy the DLLs? Am I missing something here?

I'm using R-2.11.1 on WinXP/7.

Best regards,
João Gonçalves.

R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Tue 29 Jun 2010 - 22:38:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 29 Jun 2010 - 23:10:43 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive