[R] unable to load package RPgSQL

[Laurent Faisnel]

Hi all,
I'm trying to install an add-on package for R called RPgSQL. Its role 
will be to link R with a PostgreSql database. I work on a Linux machine.
However, I'm quite a newbie as far as R's concerned, and I don't manage 
to install the package properly.
That's the steps I followed :

    * downloading the package (archive) 
    * R CMD INSTALL /path/to/package.tar.gz (as indicated in docs) - at
      that moment I had an error about unspecified directories for
      PostgreSql , so I used the option  --configure-args to specify
      where are the PostgreSql libraries and headers.
    * The installation then seemed to be a success : 

------------------------------------------------------------------------

R CMD INSTALL /home/faisnel/PostGresSql/RPgSQL_1.0-0.tar.gz 
--configure-args='--with-pgsql-libraries=/usr/local/pgsql/lib 
--with-pgsql-includes=/usr/local/pgsql/include'
* Installing *source* package 'RPgSQL' ...
creating cache ./config.cache
checking for crypt in -lcrypt... yes
checking how to run the C preprocessor... cc -E
checking for /usr/include/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /usr/include/pgsql/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /usr/include/postgresql/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /usr/local/include/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /usr/local/include/pgsql/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /usr/local/include/postgresql/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /opt/include/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /opt/include/pgsql/libpq-fe.h... no
checking how to run the C preprocessor... cc -E
checking for /opt/include/postgresql/libpq-fe.h... no
updating cache ./config.cache
creating ./config.status
creating src/Makevars
** libs
gcc -I/usr/lib/R/include -I/usr/local/pgsql/include  -D__NO_MATH_INLINES 
-mieee-fp  -fPIC  -O2 -march=i386 -mcpu=i686 -c RPgSQL.c -o RPgSQL.o
gcc -shared -L/usr/local/lib -o RPgSQL.so RPgSQL.o -lcrypt 
-L/usr/local/pgsql/lib -lpq
** R
** help
 >>> Building/Updating help pages for package 'RPgSQL'
     Formats: text html latex example
  db.result.get.value               text    html    latex   example
  db.write.table                    text    html    latex   example
  psql                              text    html    latex
  rpgsql.connections                text    html    latex
  rpgsql.execute.query              text    html    latex   example
  rpgsql.input                      text    html    latex   example
  rpgsql.list.contents              text    html    latex   example
  rpgsql.proxy                      text    html    latex   example
  rpgsql.result.attributes          text    html    latex
  rpgsql.type.conversions           text    html    latex   example
  rpgsql.utils                      text    html    latex
  sql.insert                        text    html    latex   example
  sql.select                        text    html    latex   example
  sql.update                        text    html    latex   example
* DONE (RPgSQL)

* DONE (INSTALL)
------------------------------------------------------------------------

However, when I try to load the package in R, it's a failure :

 > library(RPgSQL)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
        unable to load shared library 
"/usr/lib/R/library/RPgSQL/libs/RPgSQL.so":
  libpq.so.3: cannot open shared object file: No such file or directory
Error in library(RPgSQL) : .First.lib failed

Thank you in advance for any help.

Laurent