Hmm. I have no idea why this seems to have worked in May, but does no longer. I think it worked on one computer, but not the others I have. (I’m now wondering if perhaps I wasn’t running R 3.1.0 Mavericks when I “successfully” installed the package.)
This is flagged as RPostgreSQL issue #61. In the meantime, the Snow Leopard package binary seems to work fine with R 3.1.0 Mavericks (I use it a lot and haven’t seen any issues after a couple of months).
Original post (2014-05-09)
# Check that this is where pg_config is for you (I use MacPorts) Sys.setenv(PG_CONFIG='/opt/local/lib/postgresql93/bin/pg_config') install.packages("RPostgreSQL", type="source")
Done! (This assumes you have the necessary development tools for compiling packages.)
As an alternative, one can get the current version from the development site. In Terminal:
cd ~ svn checkout http://rpostgresql.googlecode.com/svn/trunk/ rpostgresql-read-only
Sys.setenv(PG_CONFIG='/opt/local/lib/postgresql93/bin/pg_config') install.packages("~/rpostgresql-read-only/RPostgreSQL/", type="source", repos=NULL)