Re: [R] RPostgreSQL libpq problem

[Bunny, lautloscrew.com]

Phil,

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

PG_CONFIG=/opt/local/lib/postgresql83/bin/pg_config

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

matt


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
                                         spec...@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@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.

______________________________________________
R-help@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.