[postgis-users] New day, new problem - now with pl/r

[Paragon Corporation]

Darrel,

Hmm that would suggest you might have the R-path wrong.  Those statements
should all be pretty fast

As noted in article, 

If you are running R version 2.12 or above on Windows, the R bin folder has
changed. Instead of bin it's bin\i386 or bin\x64

 

Also you want to make sure you restart postgres service after setting the
environment variables, since it doesn't take effect until relaunch.

 

Which version of R are you running?  I'm running R 3.2.2 x64 with PostgreSQL
9.4.5, compiled by Visual C++ build 1800, 64-bit  and plr 8.3.0.16

It's possible things have changed since I installed, but all those commands
work pretty fast on my database.

 

 

Thanks,

Regina

http://www.postgis.us

http://postgis.net

 

 

 

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Darrel Maddy
Sent: Sunday, November 08, 2015 10:23 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [postgis-users] New day, new problem - now with pl/r

 

Dear all,

 

Not sure if this is the right place to ask this but.

 

I have just installed the plr extension  using the instructions given here:

http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tu
t01

Setting both the path and R_Home variables.

 

The extension shows up in PGAdmin for this database.

 

I tried to check the installation using the suggested commands

SELECT * FROM plr_environ();

SELECT load_r_typenames();

SELECT * FROM r_typenames();

SELECT plr_array_accum('{23,35}', 42);

 

The first of these runs but the second command seems to go into an endless
loop (I stopped this after one hour- I assume it should not take that
long?). I assume the failure to finish means there is a problem seeing the r
typenames? As it does not fall over there is no error message to help. 

 

I am open to any suggestions how to proceed.

 

Darrel

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151108/81142c7e/attachment.html>