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