Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 24BAD475F0D for ; Sat, 14 Sep 2002 14:30:14 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8977D475EEE for ; Sat, 14 Sep 2002 14:30:13 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8EIUD5D002076; Sat, 14 Sep 2002 14:30:13 -0400 (EDT) To: Adam Witney Cc: pgsql-interfaces Subject: Re: Connecting R to PostgreSQL In-reply-to: References: Comments: In-reply-to Adam Witney message dated "Sat, 14 Sep 2002 15:29:47 +0100" Date: Sat, 14 Sep 2002 14:30:13 -0400 Message-ID: <2075.1032028213@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/55 X-Sequence-Number: 3116 Adam Witney writes: > The driver installs ok, however when I try to load it in R I get the > following error >> library(Rdbi.PgSQL) > Error in dyn.load(x, as.logical(local), as.logical(now)) : > unable to load shared library "/Users/adam/Projects/R > stuff/rlibs/Rdbi.PgSQL/libs/Rdbi.PgSQL.so": > dlcompat: dyld: /sw/lib/R/bin/R.bin Undefined symbols: > _ERR_get_error > _ERR_reason_error_string > _SSL_CTX_new > _SSL_connect > _SSL_free > _SSL_library_init It looks like the dynamic loader is failing to find the SSL library (libssl.so), which is required by your PG client library. I don't know enough about OSX to know how library searching is handled, but on other Unixen you'd need to mess with ldconfig or LD_LIBRARY_PATH ... or perhaps easier, put libssl.so into a more standard location than wherever it is now. Alternatively, you could rebuild PG omitting SSL support. regards, tom lane