[R] RPostgreSQL libpq problem
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
> before the -lpq in your compile line, R should be able to find the
> library. If you've already compiled it, try
> export DYLD_LIBRARY_PATH=/directory/with/the/library
> before starting R, or from within R, try typing
> 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
>> 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
>> R-help at r-project.org mailing list
>> 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