RdbiPgSQL, OS X, and the location of libpq.5.dylib
This is really a PostgreSQL-on-MacOS question. On a modern Unix- alike you tell ld.so about such paths via entries in /etc/ ld.so.conf.d, but then on all my systems libpq has been installed in standard places. I think you need to ask on a MacOS list (e.g. r-sig-mac) if no MacOS guru answers here.
That's my next step, but the one thing that I'd like to check beforehand relates to:
dlopen(/Library/Frameworks/R.framework/Resources/library/RdbiPgSQL/ libs/i386/RdbiPgSQL.so, 6): Library not loaded: /usr/local/pgsql/ lib/libpq.5.dylib
Has RdbiPgSQL hardcoded the path to libpq such that the library must be in that location? My understanding of Unix-alike dynamic loading isn't the best, but looking at the error my impression is that even if I do add a new location to DYLD_LIBRARY_PATH that the hardcoded path will be the only one searched. This might again be a MacOS question, but I'm wondering if anyone has been able to use a prebuilt RdbiPgSQL binary with Postgres in a non-standard location? Thanks! Jason P.S. The symnlink solution is working, but doesn't feel as elegant as I'd like... but I am able to get things done. Big thanks to the RdbiPgSQL developers for allowing me to avoid using ODBC!