Connect to Postgres using R on MacOS Mavericks + later

gistfile1.txt

# install_postgres.notes

# Notes on install RPostgreSQL on MAC OS X Mavericks & later
# original source:
# http://computersandbuildings.com/how-to-install-rpostgresql-on-osx-mavericks/:

1) install.packages('devtools') (if don't already have them)
2) install.packages('DBI')
3) download source RPostgreSQL tarball from:
  http://cran.r-project.org/web/packages/RPostgreSQL/index.html
  >>> DON'T UNTAR
4) brew install postgresql
# 'libpq-fe.h' file not found
5) sudo ln -s /usr/local/Cellar/postgresql/9.4.0/bin/pg_config /usr/local/bin/
# Library not loaded: /usr/local/opt/postgresql/lib/libpq.5.dylib
6) sudo ln -s /usr/local/Cellar/postgresql /usr/local/opt/postgresql
7) sudo R CMD INSTALL /path/to/tarball/RPostgreSQL_0.4.tar.gz