Chris Chou

tried port install libpqxx….

then install package in R gives

install.packages(c(“/Users/jon/Downloads/RPostgreSQL_0.1-6.tar.gz”), type=”source”)
inferring ‘repos = NULL’ from the file name
During startup – Warning messages:
1: Setting LC_CTYPE failed, using “C”
2: Setting LC_TIME failed, using “C”
3: Setting LC_MESSAGES failed, using “C”
* 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… /usr/local/bin/pg_config
checking for “/opt/local/include/postgresql84/libpq-fe.h”… yes
configure: creating ./config.status
config.status: creating src/Makevars
** libs
** arch – x86_64
gcc -arch x86_64 -std=gnu99 -I/Library/Frameworks/R.framework/Resources/include -I/Library/Frameworks/R.framework/Resources/include/x86_64 -I/opt/local/include/postgresql84 -I/usr/local/include -fPIC -g -O2 -c RS-DBI.c -o RS-DBI.o
gcc -arch x86_64 -std=gnu99 -I/Library/Frameworks/R.framework/Resources/include -I/Library/Frameworks/R.framework/Resources/include/x86_64 -I/opt/local/include/postgresql84 -I/usr/local/include -fPIC -g -O2 -c RS-PostgreSQL.c -o RS-PostgreSQL.o
gcc -arch x86_64 -std=gnu99 -dynamiclib -Wl,-headerpad_max_install_names -undefined dynamic_lookup -single_module -multiply_defined suppress -L/usr/local/lib -o RPostgreSQL.so RS-DBI.o RS-PostgreSQL.o -L/opt/local/lib/postgresql84 -lpq -F/Library/Frameworks/R.framework/.. -framework R -Wl,-framework -Wl,CoreFoundation
ld warning: in /opt/local/lib/postgresql84/libpq.dylib, file is not of required architecture
** R
** inst
** preparing package for lazy loading
Warning: package ‘DBI’ was built under R version 2.10.1
Creating a new generic function for “format” in “RPostgreSQL”
Creating a new generic function for “print” in “RPostgreSQL”
** help
*** installing help indices
** building package indices …
* DONE (RPostgreSQL)

loading library gives:

library(RPostgreSQL)
Error in dyn.load(file, DLLpath = DLLpath, …) :
unable to load shared library ‘/Library/Frameworks/R.framework/Resources/library/RPostgreSQL/libs/x86_64/RPostgreSQL.so’:
dlopen(/Library/Frameworks/R.framework/Resources/library/RPostgreSQL/libs/x86_64/RPostgreSQL.so, 6): Symbol not found: _PQbackendPID
Referenced from: /Library/Frameworks/R.framework/Resources/library/RPostgreSQL/libs/x86_64/RPostgreSQL.so
Expected in: dynamic lookup

Error: package/namespace load failed for ‘RPostgreSQL’

stuck now. Sorry for posting so much here, just delete if its annoying. really would like postgres to work well with R but its fairly high tech to get it to work it seems

Jon

Thanks! I finally installed it.

RPostreSQL seemed to break with R 2.13. But I got it to work by downloading the package from CRAN (http://cran.r-project.org/web/packages/RPostgreSQL/index.html) to my ~/Downloads folder. Then (from ~/Downloads) I enter the following into the terminal:
tar xvzf RPostgreSQL_0.1-7.tar
followed by editing the configure file in the ~/Downloads/RPostgreSQL directory as follows. Find the portion of the file that looks like this:

if ! test $PG_INCDIR
then
for dir in \
/usr/include \

then add the path to libpq-fe.h to the list of directories searched. After editing, it looks like this:

if ! test $PG_INCDIR
then
for dir in \
/Library/PostgreSQL/9.0/include \
/usr/include \

Then I went to R and entered:
install.packages(“~/Downloads/RPostgreSQL”, repos = NULL, type=”source”)

Voila!

Many thanks- easy fix!