Greetings,

I am having a problem installing RdbiPgSQL on Centos 5.5 machine,
running on Dell hardware.  The version of R I am using is 2.11.1 and
Postgres  version is 8.4.4.

I have set the following environment variables:
  PGHOST=dasher
  PG_LIB_DIR=/usr/local/pgsql/lib
  PG_INCLUDE_DIR=//usr/local/pgsql/include
and ran two commands below from R:
  source("http://bioconductor.org/biocLite.R")
  biocLite("RdbiPgSQL")

What happens is:
  Error in dyn.load(file, DLLpath = DLLpath, ...) :
    unable to load shared library '/usr/local/lib64/R/library/RdbiPgSQL/libs/RdbiPgSQL.so':
    libpq.so.5: cannot open shared object file: No such file or directory
  ERROR: loading failed

Would someone please give me some idea how to get this corrected?

Thank you in advance.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

Below is the entire session of what happens.
===========================================


  [root@dasher Scripts]# R

  R version 2.11.1 (2010-05-31)
  Copyright (C) 2010 The R Foundation for Statistical Computing
  ISBN 3-900051-07-0

  R is free software and comes with ABSOLUTELY NO WARRANTY.
  You are welcome to redistribute it under certain conditions.
  Type 'license()' or 'licence()' for distribution details.

    Natural language support but running in an English locale

  R is a collaborative project with many contributors.
  Type 'contributors()' for more information and
  'citation()' on how to cite R or R packages in publications.

  Type 'demo()' for some demos, 'help()' for on-line help, or
  'help.start()' for an HTML browser interface to help.
  Type 'q()' to quit R.

  > Sys.getenv('PGHOST')
    PGHOST
  "dasher"
  >
  > Sys.getenv('PG_LIB_DIR')
              PG_LIB_DIR
  "/usr/local/pgsql/lib"
  >
  > Sys.getenv('PG_INCLUDE_DIR')
               PG_INCLUDE_DIR
  "//usr/local/pgsql/include"
  >
  > source("http://bioconductor.org/biocLite.R")
  BioC_mirror = http://www.bioconductor.org
  Change using chooseBioCmirror().
  >
  > biocLite("RdbiPgSQL")
  Using R version 2.11.1, biocinstall version 2.6.8.
  Installing Bioconductor version 2.6 packages:
  [1] "RdbiPgSQL"
  Please wait...

  trying URL 'http://www.bioconductor.org/packages/2.6/bioc/src/contrib/RdbiPgSQL_1.22.0.tar.gz'
  Content type 'application/x-gzip' length 28079 bytes (27 Kb)
  opened URL
  ==================================================
  downloaded 27 Kb

  * installing *source* package āRdbiPgSQLā ...
  creating cache ./config.cache
  updating cache ./config.cache
  creating ./config.status
  creating src/Makevars
  ** libs
  gcc -std=gnu99 -I/usr/local/lib64/R/include -I//usr/local/pgsql/include -I/usr/local/include    -fpic  -g -O2 -c PgSQL.c -o PgSQL.o
  gcc -std=gnu99 -I/usr/local/lib64/R/include -I//usr/local/pgsql/include -I/usr/local/include    -fpic  -g -O2 -c PgSQLInit.c -o PgSQLInit.o
  gcc -std=gnu99 -shared -L/usr/local/lib64 -o RdbiPgSQL.so PgSQL.o PgSQLInit.o -L/usr/local/pgsql/lib -lpq
  installing to /usr/local/lib64/R/library/RdbiPgSQL/libs
  ** R
  ** preparing package for lazy loading
  ** help
  *** installing help indices
  ** building package indices ...
  ** testing if installed package can be loaded
  Error in dyn.load(file, DLLpath = DLLpath, ...) :
    unable to load shared library '/usr/local/lib64/R/library/RdbiPgSQL/libs/RdbiPgSQL.so':
    libpq.so.5: cannot open shared object file: No such file or directory
  ERROR: loading failed
  * removing ā/usr/local/lib64/R/library/RdbiPgSQLā

  The downloaded packages are in
          ā/tmp/Rtmpr9mGSM/downloaded_packagesā
  Updating HTML index of packages in '.Library'
  Warning message:
  In install.packages(pkgs = pkgs, repos = repos, ...) :
    installation of package 'RdbiPgSQL' had non-zero exit status
  >
  > q()
  Save workspace image? [y/n/c]: n
  [root@dasher Scripts]#

	[[alternative HTML version deleted]]

