> library(RPostgreSQL) Error in library(RPostgreSQL) : there is no package called ‘RPostgreSQL’ > install.packages("RPostgreSQL") Installing package(s) into ‘/home/andrew/R/i686-pc-linux-gnu-library/2.15’ (as ‘lib’ is unspecified) trying URL 'http://cran.rstudio.com/src/contrib/RPostgreSQL_0.4.tar.gz' Content type 'application/x-gzip' length 477352 bytes (466 Kb) opened URL ================================================== downloaded 466 Kb * installing *source* package ‘RPostgreSQL’ ... ** package ‘RPostgreSQL’ successfully unpacked and MD5 sums checked checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking for pg_config... no configure: checking for PostgreSQL header files configure: Checking include /usr/include. configure: Checking include /usr/include/pgsql. configure: Checking include /usr/include/postgresql. configure: Checking include /usr/local/include. configure: Checking include /usr/local/include/pgsql. configure: Checking include /usr/local/include/postgresql. configure: Checking include /usr/local/pgsql/include. configure: Checking include /usr/local/postgresql/include. configure: Checking include /opt/include. configure: Checking include /opt/include/pgsql. configure: Checking include /opt/include/postgresql. configure: Checking include /opt/local/include. configure: Checking include /opt/local/include/postgresql. configure: Checking include /opt/local/include/postgresql84. configure: Checking include /sw/opt/postgresql-8.4/include. configure: Checking include /Library/PostgresPlus/8.4SS/include. configure: Checking include /sw/include/postgresql. configure: Checking lib /usr/lib. configure: Checking lib /usr/lib/pgsql. configure: Checking lib /usr/lib/postgresql. configure: Checking lib /usr/local/lib. configure: Checking lib /usr/local/lib/pgsql. configure: Checking lib /usr/local/lib/postgresql. configure: Checking lib /usr/local/pgsql/lib. configure: Checking lib /usr/local/postgresql/lib. configure: Checking lib /opt/lib. configure: Checking lib /opt/lib/pgsql. configure: Checking lib /opt/lib/postgresql. configure: Checking lib /opt/local/lib. configure: Checking lib /opt/local/lib/postgresql. configure: Checking lib /opt/local/lib/postgresql84. configure: Checking lib /sw/opt/postgresql-8.4/lib. configure: Checking lib /Library/PostgresPlus/8.4SS/lib. configure: Checking lib /sw/lib. checking for "/libpq-fe.h"... no configure: creating ./config.status config.status: creating src/Makevars ** libs gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I -fpic -O2 -pipe -g -c RS-DBI.c -o RS-DBI.o gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I -fpic -O2 -pipe -g -c RS-PQescape.c -o RS-PQescape.o In file included from RS-PQescape.c:7:0: RS-PostgreSQL.h:23:26: fatal error: libpq-fe.h: No such file or directory compilation terminated. make: *** [RS-PQescape.o] Error 1 ERROR: compilation failed for package ‘RPostgreSQL’ * removing ‘/home/andrew/R/i686-pc-linux-gnu-library/2.15/RPostgreSQL’ Warning in install.packages : installation of package ‘RPostgreSQL’ had non-zero exit status The downloaded source packages are in ‘/tmp/RtmpiJNvZP/downloaded_packages’