Re: Using PL/R with 8.0

Yahoo!  The edit of /etc/ld.so.conf and running ldconfig
worked.  

Thank you.

--elein

On Thu, Mar 10, 2005 at 12:27:59AM -0800, Joe Conway wrote:
> 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
>