Dear all, I'm an absolute R-beginner and want to connect to my PostgreSQL DB
(on my local Mac OSX 10.6).
1) I tried to install RPostgreSQL (Package Installer > CRAN (sources)) and
get this log below. There seems to be an issue with libpq, bug I don't have
any clue how to fix this. What can I do?
2) Once this issue is solved, should this code work?
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv,user="postgresql",password=password,dbname="DB")
dbSendQuery(con,"create table testTab as select * from Tab")
dbDisconnect(con)
dbUnloadDriver(drv)
Thanks, Tom
trying URL
'http://cran.ch.r-project.org/src/contrib/RPostgreSQL_0.1-6.tar.gz'
Content type 'application/x-gzip' length 141399 bytes (138 Kb)
opened URL
==================================================
downloaded 138 Kb
* installing *source* package ‘RPostgreSQL’ ...
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 for pg_config... no
configure: checking for PostgreSQL header files
checking for "/libpq-fe.h"... no
configure: error: File libpq-fe.h not in ; installation may be broken.
ERROR: configuration failed for package ‘RPostgreSQL’
* removing
‘/Library/Frameworks/R.framework/Versions/2.10/Resources/library/RPostgreSQL’
The downloaded packages are in
‘/private/var/folders/sA/sArT9JYcG9qiUI-T+f3TZE+++TI/-Tmp-/RtmpEeMtM8/downloaded_packages’
--
View this message in context:
http://old.nabble.com/Install-RPostgreSQL-%28Mac-OSX-10.6%29-tp26503444p26503444.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
