[R-sig-DB] PostgreSQL

[Joe Conway]

Tom Dye wrote:
> 
> RdbiPgSQL is available as source, and even with
> export PG_LIB_DIR=/usr/local/pgsql/lib/ and
> export PG_INCLUDE_DIR=/usr/local/pgsql/include/
> fails to install with the following messages:

[snip]

> I could not find your PostgreSQL client libraries!
> Use --with-pgsql-libraries=PATH; if running R's INSTALL,
> use --configure-args='--with-pgsql-libraries=PATH'; or
> set PG_LIB_DIR in your environment to the library path,
> and rerun the configure/install.
> 
> ERROR: configuration failed for package 'RdbiPgSQL'

Is libpq.so really in /usr/local/pgsql/lib (R doesn't think so)? If not, 
find it, and point PG_LIB_DIR to that location. Unfortunately I can't 
really help you in terms of finding where the Postgres client libraries 
are located on a Mac. You may have a similar issue with PG_INCLUDE_DIR.

Joe