From: Adam Witney <awitney@sghms.ac.uk>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Connecting R to PostgreSQL
Date: Sat, 14 Sep 2002 15:29:47 +0100
Message-ID: <B9A9066B.7985%a.witney@sghms.ac.uk> (raw)
Hi,
I am not sure if the problem here relates to PostgreSQL or elsewhere, but I
am trying to connect the R statistical package to my PostgreSQL database
using the Rdbi.PgSQL driver.
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
_SSL_load_error_strings
_SSL_new
_SSL_read
_SSL_set_fd
_SSL_write
_SSLv23_method
Error in library(Rdbi.PgSQL) : .First.lib failed
Looking through the source code the driver includes <libpq-fe.h> which
subsequently includes openssl/ssl.h
I don't know if this is where the problem lies?
My system is Mac OSX 10.2
Any ideas or pointers to further information would be greatly appreciated.
Thanks
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: awitney@sghms.ac.uk
Subject: Re: Connecting R to PostgreSQL
In-Reply-To: <B9A9066B.7985%a.witney@sghms.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox