Re: PLR Help

From: Joe Conway <mail(at)joeconway(dot)com>
To: Daniel Cole <daniel(at)southernsolutionsms(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PLR Help
Date: 2012-05-02 19:59:10
Message-ID: 4FA1920E.7010505@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/02/2012 03:01 AM, Daniel Cole wrote:
> I finally got R to make after some help on this list, but now I am

Does this imply you built R from source, or did you actually install R
and R dev from deb packages?

If you built R from source you need to use the correct configure switch
to ensure the dynamic library gets built, because the default is to not
build it.

> *sudo psql -d testdb9 -U testdbuser < plr.sql*
>
> and I get result at the bottom of this email.

> I believe that it has to do either with not having $R_Home set correctly
> (I can't find must documentation on this) or it has do to with not
> having the libR findable by my runtime linker. ( I tried adding the
> following to a file that is loaded by /etc/ld.so.conf ) The lines I
> loaded to that file are:
> /usr/lib/R/bin
> /usr/lib/R/
> /usr/lib/postgresql/9.1/lib/

> ERROR: could not load library "/usr/lib/postgresql/9.1/lib/plr.so":
> libR.so: cannot open shared object file: No such file or directory

This error is typically because libR.so is not being found. I am not in
a position to check at the moment, but I believe current packaged
versions of R place the shared object here:

/usr/lib/R/lib

First, go find lib.R.so. Assuming it is in the above location, place
that location in your /etc/ld.so.conf and run ldconfig.

HTH,

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support

In response to

  • PLR Help at 2012-05-02 12:01:24 from Daniel Cole

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2012-05-02 20:07:16 Re: PLR Help
Previous Message Bruce Momjian 2012-05-02 18:42:03 Re: Limit the normal user to see system catalog or not??? And create privilege???