[BioC] Rdbi.PgSQL

[Hrishikesh Deshmukh]

Hi,

I am using Debian linux, i use apt-get to install
postgresql and installation is all done by apt-get
install command! Any pointers how to find postgresql
client libs on debian!

Thanks,
Hrishi

> library(reposTools)
Loading required package: tools 
> install.packages2("RdbiPgSQL")
Note: Using download type: Source 
[1] "Attempting to download RdbiPgSQL from
http://www.bioconductor.org/repository/release1.5/package/Source"
[1] "Download complete."
[1] "Installing RdbiPgSQL"
* Installing *source* package 'RdbiPgSQL' ...
creating cache ./config.cache
checking for PQconnectdb in -lpq... no

I could not find your PostgreSQL client libraries!
Use --with-pgsql-libraries=PATH; if running R's
INSTALL,
use --configure-args='--with-pgsql-libraries=PATH'; or
set PG_LIB_DIR in your environment to the library
path,
and rerun the configure/install.

ERROR: configuration failed for package 'RdbiPgSQL'
>From URL: 
http://www.bioconductor.org/repository/release1.5/package/Source
        RdbiPgSQL version 1.0.9

Warning message: 
Installation of package RdbiPgSQL had non-zero exit
status in: installPkg(fileName, pkg, pkgVer, type,
lib, repEntry, versForce) 
> sessionInfo()
R version 2.0.1, 2004-11-15, i386-pc-linux-gnu 

attached base packages:
[1] "tools"     "methods"   "stats"     "graphics" 
"grDevices" "utils"    
[7] "datasets"  "base"     

other attached packages:
reposTools 
  "1.5.14" 

--- Seth Falcon <sfalcon at fhcrc.org> wrote:
> Hi Hrishi,
> 
> I just tried getBioC("database") and the RdbiPgSQL
> didn't get
> downloaded.  The Rdbi package did get installed.  I
> will look into
> this.
> 
> Note, however, that the RdbiPgSQL package is only
> available as a
> Source package --- that is, if you are using
> Windows, you may not be
> able to use this package at this time.
> 
> If you are on Linux you can use reposTools to
> install the RdbiPgSQL
> package:
> 
> library(reposTools)
> install.packages2("RdbiPgSQL")
> 
> Hope that helps some.
> 
> As an aside, please remind us of your platform, R
> version, package
> versions as a part of your posts.  A nice way to do
> this is to include
> the output of sessionInfo().
> 
> + seth
> 
> 
> Hrishikesh Deshmukh <d_hrishikesh at yahoo.com> writes:
> 
> > Hi,
> >
> > I am trying to connect test DB in postgres and i
> have
> > installed RdbiPgSQL; getBioC("database") option,
> yet i
> > get this error!
> > library(RdbiPgSQL)
> > Error in library(RdbiPgSQL) : There is no package
> > called 'RdbiPgSQL'
> >
> > Why i am unable to figure out.
> >
> > Thanks,
> > Hrishi
> >
> > _______________________________________________
> > Bioconductor mailing list
> > Bioconductor at stat.math.ethz.ch
> > https://stat.ethz.ch/mailman/listinfo/bioconductor
> 
> _______________________________________________
> Bioconductor mailing list
> Bioconductor at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/bioconductor
>