Installing Mac EnterprizeDB Postgres Standard Fails

On 5 January 2010 at 12:49, Nils B. Weidmann wrote:
Neil, Dirk,

thanks for your help! I finally managed to compile and install the 
package. Two issues:

* Setting the location of the PG header files as shown on the Wiki page 
does not seem to have any effect. Also, changing the search lists in 
configure and configure.in still gives the same error. Due to my lack of 
knowledge about (auto)configure, I manually override the paths for the 
libs and includes in configure by adding

PG_INCDIR=/Library/PostgresPlus/8.4SS/include
PG_LIBDIR=/Library/PostgresPlus/8.4SS/lib

at around line 2675 (after the directories are tested). These are the 
paths for the EnterprizeDB Postgres Standard Server (8.4) I am using. 
Compilation now starts (but see below). Still, this suggests to me that 
there is a problem in the configure script, which causes the PG_*DIR 
variables not to be set at all. This would also explain why the CRAN 
version does not compile (with the Fink PG libs installed).

* For OS X Users, R needs to be called with the arch flag correctly set, 
as in

 > sudo R --arch=i386 CMD INSTALL RPostgreSQL

The default R call compiles a 64-bit package, but installs it under 
32-bit R, which results in an error when the package is loaded. Maybe 
this is worth adding to the Wiki.

Original issue reported on code.google.com by ne...@neiltiffin.com on 5 Jan 2010 at 9:28

yueshengu / rpostgresql

Installing Mac EnterprizeDB Postgres Standard Fails #12