[R-sig-DB] PostgreSQL

[Joe Conway]

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