[R] Re: Install problems with RPgSQL

Rainer Hurling rhurlin at gwdg.de
Fri Feb 11 08:07:48 CET 2000

"Timothy H. Keitt" wrote:
> If you have had problems with the latest configure script in RPgSQL,
> please try the version attached to this message.  Let me know if you
> have any problems.  Thanks.
> Tim

Sorry about my pausing in looking for a solution to install on a
FreeBSD-3.4 machine. PostgreSQL-6.5.3 is located at /usr/local/pgsql
with libraries in /usr/local/pgsql/lib and headers in
/usr/local/pgsql/include. This seems to be standard location on FreeBSD
machines (?).

I was confused on how to install your package the right way, because the
gcc did not found lpq on his place. 

Here my solution. It has two steps and works fine with your newest
version RPgSQL_0.5-1.tar.gz.

First I have to set two variables:

    setenv PG_LIB_DIR     /usr/local/pgsql/lib
    setenv PG_INCLUDE_DIR /usr/local/pgsql/include

Second I have to patch the configure script at line 577:


    576    if test $PG_LIB_DIR; then
    577       PKG_LIBS="$PKG_LIBS -L$PG_LIB_DIR -lpq"
    578       PKG_LDFLAGS="-L${PG_LIB_DIR}"
    579    else

Do you think it's possible to integrate these two changes in your


r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list