Message-ID: <4230050F.4000206@joeconway.com>
Date: Thu, 10 Mar 2005 00:27:59 -0800
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20041020
MIME-Version: 1.0
To: elein <elein@varlena.com>
Cc: postgresql <pgsql-interfaces@postgresql.org>
Subject: Re: Using PL/R with 8.0
References: <20050309033614.GR5165@varlena.com>
In-Reply-To: <20050309033614.GR5165@varlena.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

elein wrote:
> I have R_HOME as /usr/lib/R
> libR.so is in /usr/lib/R/lib/libR.so
> and has rw-r--r-- permissions.
> 
> /u/local/pgsql80/lib/plr.so is rwxr-xr-x.
> 
> I've (re)built pg --with-plr and --with-libs=/usr/lib/R/ (just in case)

I doubt this does anything useful at best. Postgres has no builtin 
support for PL/R.

> 
> When I load plr.sql it complains:
> ERROR:  could not load library "/u/local/pgsql80/lib/plr.so": libR.so: cannot open shared object file: No such file or directory

Try either:
  export LD_LIBRARY_PATH=/usr/lib/R/lib:$LD_LIBRARY_PATH
as the postgres user (or whatever user owns the cluster)
or edit /etc/ld.so.conf, add /usr/lib/R/lib, run ldconfig.

Joe