PLR Help

Поиск
Список
Период
Сортировка
От Daniel Cole
Тема PLR Help
Дата
Msg-id CAE6KOUjmmR+2Hx6G2BAf65Uu8LZ5gZreTawfaF10TNJDZBEdpg@mail.gmail.com
обсуждение исходный текст
Ответы Re: PLR Help  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: PLR Help  (Joe Conway <mail@joeconway.com>)
Список pgsql-general

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

В списке pgsql-general по дате отправления:

Предыдущее
От: "STERBECQ Didier"
Дата:
Сообщение: RE : Postgres 8.x on Linux : how to use HugePages
Следующее
От: Chrishelring
Дата:
Сообщение: Uppercase to lowercase trigger?