
On Sep 29, 2009, at 8:21 PM, Dirk Eddelbuettel wrote:
> Jeff,
>
> On 29 September 2009 at 17:50, Jeff Hamann wrote:
> | I can't get the RPostgreSQL library to load on OSX and have no idea
> | where it's going wrong...
> |
> |  > library( RPostgreSQL )
> | Error in dyn.load(file, DLLpath = DLLpath, ...) :
> |    unable to load shared library '/Users/hamannj/Library/R/2.9/ 
> library/
> | RPostgreSQL/libs/i386/RPostgreSQL.so':
> |    dlopen(/Users/hamannj/Library/R/2.9/library/RPostgreSQL/libs/ 
> i386/
> | RPostgreSQL.so, 6): Symbol not found: _PQbackendPID
> |    Referenced from: /Users/hamannj/Library/R/2.9/library/ 
> RPostgreSQL/
> | libs/i386/RPostgreSQL.so
> |    Expected in: flat namespace
> |   in /Users/hamannj/Library/R/2.9/library/RPostgreSQL/libs/i386/
> | RPostgreSQL.so
> | Error: package/namespace load failed for 'RPostgreSQL'
>
> As you know, questions / complaints about contributed packages  
> should go to
> the maintainer first, i.e. me. Now, I do not have access to OS X --  
> but Neil
> (CC'ed) kindly covers that angle.  Maybe the two of you can sort  
> this out?
>
> | I've used this on OSX before and have had to recently rebuild...  
> does
> | anyone know if an older archive works?
>
> The current version works for other on OS X as far as I know.
>

RPostgreSQL is only available is source form. There are many different  
ways to install postgreSQL.  I suspect the normal source compile from  
within R failed.  If you were installing a bunch of packages you may  
have not seen the failure.

Please email how you installed postgresql, what version of postgresql  
you have installed, and how you source compiled RPostgreSQL.  I  
suspect this will illuminate the problem.

I install postgresql with fink and use the following to install  
RPostgreSQL.  It is working for me with R 9.2.1.  Of course if you use  
a different source for postgresql itself, you will need to change the  
line below.  You can try to download the source, cd into the source  
location and execute the command line below with any modifications for  
your installation.

	sudo R CMD INSTALL RPostgreSQL_0.1-4.tar.gz --configure-args='--with- 
pgsql-libraries=/sw/lib/postgresql-8.3 --with-pgsql-includes=/sw/ 
include/postgresql'

Sorry I did not see this as I only monitor R-Sig-Mac and R-Sig-DB.

Neil


	[[alternative HTML version deleted]]

