PLR Help

Ubuntu 10.04, Lucid

Everything below installed by apt-get:
Postgres 9.1
Postgres 9.1 dev
PostGis
R-base
R-base-Dev

I have wanted to install the PLR via the postgresql-9.1.-plr package, but
there doesn't seem to be one for 10.04.

I finally got R to make after some help on this list, but now I am trying
to put the plr.sql on a database and its failing. I have read through the
instruction page, but know I am not do everything just right in the tips.

So what I am trying to run is this:

*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/

that last one was just in case that worked. Please can anyone give me an
idea how to get PLR running. It is hopefully my last stumbling block
before my script that requires R and PLR will run.

Thanks,

Daniel

retunr data from: *sudo psql -d testdb9 -U mkadmin < plr.sql*

**********************************************

SET
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
ERROR: function plr_call_handler() does not exist
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
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
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
ERROR: function install_rcmd(text) does not exist
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
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
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
ERROR: type "plr_environ_type" already exists
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
ERROR: function plr_environ() does not exist
ERROR: type "r_typename" already exists
ERROR: language "plr" does not exist
ERROR: language "plr" does not exist
ERROR: type "r_version_type" already exists
ERROR: language "plr" does not exist
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
ERROR: function plr_set_rhome(text) does not exist
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
ERROR: function plr_unset_rhome() does not exist
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
ERROR: function plr_set_display(text) does not exist
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

**********************************************

-----------------------------------------------------------
Daniel Cole