[R] RPostgreSQL libpq problem

Bunny, lautloscrew.com bunny at lautloscrew.com
Fri Aug 28 17:04:12 CEST 2009


thx a lot for your suggestions.. Luckily I was just able to find a  
solution. I just recompiled everything, deleting my manually set vars  
PG_INCDIR and PG_LIBDIR and setting


in line 2564 of the configure file

then starting the installation directly via R. after that everything  
was straight forward, just using library(RPostgreSQL) .

Maybe this helps some mac users on the list in future


Am 28.08.2009 um 16:46 schrieb Phil Spector:

> Matt -
>   If you include a
>          -L/directory/with/the/library
> before the -lpq in your compile line, R should be able to find the  
> library.  If you've already compiled it, try
> typing
> export  DYLD_LIBRARY_PATH=/directory/with/the/library
> before starting R, or from within R, try typing
> Sys.setenv(DYLD_LIBRARY_PATH='/directory/with/the/library')
> before loading the package.
> 					- Phil Spector
> 					 Statistical Computing Facility
> 					 Department of Statistics
> 					 UC Berkeley
> 					 spector at stat.berkeley.edu
> On Fri, 28 Aug 2009, Bunny, lautloscrew.com wrote:
>> Dear all,
>> I am stuck trying to get RPostgreSQL running on my Mac. PostgreSQL  
>> itself does work fine as it is able to connect with various other  
>> apps.
>> Unfortunately the RPostgreSQL package is not available as a binary  
>> for MAC OS. Thus I´ve been trying to compile the source for quite  
>> some time now - unfortunately without success (or at least very  
>> limited success).
>> First,  running ./configure  respectively running the installation  
>> directly via R was not able to find the header file libpq-fe.h.  
>> after I changed PG_INCDIR to my
>> local postgre dir the error message disappear and i got another one:
>> ld: library not found for -lpq
>> Thus I tried to set PG_LIBDIR to the directory where libpq is  
>> located, but still I received the same error message, despite a  
>> encouraging libpq-fe.h ...yes
>> Does anybody know how to fix this?
>> Thx in advance
>> matt
>> ______________________________________________
>> 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.

More information about the R-help mailing list