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
