[R-sig-DB] PostgreSQL
Joe Conway
m@|| @end|ng |rom joeconw@y@com
Tue Sep 6 00:58:21 CEST 2005
Tom Dye wrote:
>
> I think you're right. Now that I have downloaded the source, are there
> installation instructions? I'm working on an eMac, OS 10.3. Is the
> package known to compile on this platform? Running autoconf, then
> configure --with-pgsql-libraries=/usr/local/pgsql/lib/, yields
> configure: error: C preprocessor "/lib/cpp" fails sanity check.
(posting back to the list so others can join in and/or benefit)
I think it also requires this:
http://www.bioconductor.org/packages/bioc/stable/src/contrib/html/Rdbi.html
I'm afraid I don't have a Mac, and to be honest have not used RdbiPgSQL
since before it was moved to Bioconductor. My needs for R are very
basic, and usually I use my own connector, PL/R (see
http://www.joeconway.com/plr/). Slightly different approach, but might
meet your needs.
Anyway, I followed the instructions here:
http://www.bioconductor.org/docs/install-howto.html
Worked for me after I set two environment variables to point to my
Postgres headers and libs. I did something like:
# export PG_LIB_DIR=/usr/local/pgsql-dev/lib
# export PG_INCLUDE_DIR=/usr/local/pgsql-dev/include
# R
R : Copyright 2005, The R Foundation for Statistical Computing
Version 2.1.1 (2005-06-20), ISBN 3-900051-07-0
<snip>
[Previously saved workspace restored]
> source("http://www.bioconductor.org/biocLite.R")
> biocLite(c("Rdbi","RdbiPgSQL"))
I haven't really tested it, but all indications are that they both
installed correctly.
HTH,
Joe
More information about the R-sig-DB
mailing list