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.