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