Neil,

I tried installing the RPostgreSQL from both within R (using  
install.packages(), and using R CMD INSTALL)... but did not try  
installing from source using the method you describe. I did install  
PostgreSQL from source and will give that a try...

(a few days later)...

I've recompiled *everything*:

	ftp http://www.pdfhacks.com/pdftk/pdftk-1.41.tar.gz
	ftp http://www.unidata.ucar.edu/downloads/netcdf/ftp/netcdf-3.6.3.tar.Z
	ftp ftp://ftp.gnu.org/gnu/glpk/glpk-4.39.tar.gz
	ftp http://download.osgeo.org/proj/proj-4.6.1.tar.gz
	ftp http://download.osgeo.org/proj/proj-datumgrid-1.4.zip
	ftp http://download.osgeo.org/geos/geos-3.0.3.tar.bz2
	ftp http://download.osgeo.org/gdal/gdal-1.6.2.tar.gz
	ftp http://cran.r-project.org/src/base/R-2/R-2.9.1.tar.gz
	ftp http://wwwmaster.postgresql.org/redir/198/h/source/v8.3.8/postgresql-8.3.8.tar.bz2
	ftp http://www.joeconway.com/plr/plr-8.3.0.8.tar.gz
	ftp http://postgis.refractions.net/download/postgis-1.4.0.tar.gz
	ftp http://grass.itc.it/grass64/source/snapshot/grass-6.4.svn_src_snapshot_2009_09_19.tar.gz
	ftp http://liblas.org/attachment/wiki/1.2.0/liblas-1.2.0-src.tar.bz2
	ftp -o gpsbabel-1.3.6.tar.gz http://www.gpsbabel.org/plan9.php?dl=gpsbabel-1.3.6.tar.gz
	ftp -v ftp://ftp2.fs.fed.us/incoming/fmsc/outgoing/fvs/fvs091109.exe

and the problem went away

 > library( RPostgreSQL )
Loading required package: DBI
 >

go figure...

Thanks for a great package... It's helping tremendously as I port code  
from seriously old R code of mine (read grad school hacks) to useful R  
code to server-side PostgreSQL PL/R modules.

I'm working on getting PL/R running again...

never a dull moment...

BTW: Love your website! Mine is about 10 years old. I don't like it. I  
originally wanted mine to look much closer to yours, but only had  
about 12 hours to commit to it back then. Interested in being my  
website "mentor" after I get my monster rebuilt?

The monster is an experimental intelligent software agent for forests,  
forestry and forestry related data that ingests data, generates  
forecasts, and optimal strategic, tactical, and operational plans for  
timberland managers.

Thanks,
Jeff.


On Sep 30, 2009, at 5:02 AM, Neil Tiffin wrote:

>
> 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
>

Jeff Hamann, PhD
PO Box 1421
Corvallis, Oregon 97339-1421
541-754-2457
jeff.hamann[at]forestinformatics[dot]com
http://www.forestinformatics.com


	[[alternative HTML version deleted]]

