Dear Mailing List, When I say:- > library("RdbiPgSQL") ...then I get the following errors:- Loading required package: Rdbi Error in dyn.load(file, DLLpath = DLLpath, ...) : unable to load shared object '/Library/Frameworks/R.framework/Versions/2.12/Resources/library/RdbiP gSQL/libs/x86_64/RdbiPgSQL.so': dlopen(/Library/Frameworks/R.framework/Versions/2.12/Resources/library /RdbiPgSQL/libs/x86_64/RdbiPgSQL.so, 6): Symbol not found: _PQbackendPID Referenced from: /Library/Frameworks/R.framework/Versions/2.12/Resources/library/RdbiPg SQL/libs/x86_64/RdbiPgSQL.so Expected in: dynamic lookup Error: package/namespace load failed for 'RdbiPgSQL' I use only binary packages for R and R itself was installed as binary. But I must admit my Postgres installation (8.4.7) was compiled from source and placed into a "nonstandard" location /usr/local/pgsql/current . But the problem persists even if I put the library path /usr/local/pgsql/current/lib in the DYLD_LIBRARY_PATH variable. This happens on a Mac Pro (64-bit Intel), with OS X 10.6.6. I would be grateful for any fixes or workaround advice. Thank you very much! PS I first sent this to the R bug tracking system but Professor Ripley advised me to submit it to Bioconductor since RdbiPgSQL is a BioC contributed package. I hope this is now the right place... [[alternative HTML version deleted]]

On Wed, Feb 23, 2011 at 3:07 AM, Aszodi,Andras <andras.aszodi@imp.ac.at>wrote: > Dear Mailing List, > > When I say:- > > > library("RdbiPgSQL") > > ...then I get the following errors:- > > Loading required package: Rdbi > Error in dyn.load(file, DLLpath = DLLpath, ...) : > unable to load shared object > > '/Library/Frameworks/R.framework/Versions/2.12/Resources/library/Rdb iPgSQL/libs/x86_64/RdbiPgSQL.so': > > > dlopen(/Library/Frameworks/R.framework/Versions/2.12/Resources/libra ry/RdbiPgSQL/libs/x86_64/RdbiPgSQL.so, > 6): Symbol not found: _PQbackendPID > Referenced from: > > /Library/Frameworks/R.framework/Versions/2.12/Resources/library/Rdbi PgSQL/libs/x86_64/RdbiPgSQL.so > Expected in: dynamic lookup > > Error: package/namespace load failed for 'RdbiPgSQL' > > I use only binary packages for R and R itself was installed as binary. But > I > must admit my Postgres installation (8.4.7) was compiled from source and > placed > into a "nonstandard" location /usr/local/pgsql/current . But the problem > persists even if I put the library path /usr/local/pgsql/current/lib in the > DYLD_LIBRARY_PATH variable. This happens on a Mac Pro (64-bit Intel), with > OS X > 10.6.6. I would be grateful for any fixes or workaround advice. Thank you > very > much! > > PS I first sent this to the R bug tracking system but Professor Ripley > advised me to submit it to Bioconductor since RdbiPgSQL is a BioC > contributed package. I hope this is now the right place... > > Hi, you don't include the output of sessionInfo(), nor explain how you installed RdbiPgSQL in the first place and whether there were any errors. You might try building RdbiPgSQL from source: source("http://bioconductor.org/biocLite.R") biocLite("RdbiPgSQL",type="source") This will give you some informative messages about how to tell the build process about your PostgreSQL installation. The pre-built version expects PostgreSQL to be in a standard location. Dan [[alternative HTML version deleted]]