[postgis-users] Installation of PL/R: Updata

[Darrel Maddy]

Dear Volkmar,

I contacted the author (Joe Conway) of the PL/R package and he confirmed that the dll had not yet been compiled for PG9.1.2 - clearly being a decent chap he quickly produced a dll for me which I am glad to report works as intended (I think he will do a little more testing before releasing it into the wild) - sometime the open source community make me glad to be alive! :).

Thumbs up also for Regina/Leo and the PostGIS in action book, Ch10 had me using PL/R in no time - so now I only have to learn postgresql, postgis and R  - sounds like some fun days ahead. No doubt I'll be back...

Darrel



From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Volkmar Herbst
Sent: 30 January 2012 07:18
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Installation of PL/R

HI,
I did install R several times and run also often into this issue. Try the 32bit  one and set the path C:\Program Files\R\R-2.13.1\bin\i386  in your environment. Create new variable R_HOME  value->C:\Program Files\R\R-2.13.1 Make sure that plr.dll is in C:\Program Files (x86)\PostgreSQL\9.0\lib. Restart postgres after that. If you receive errors check if you did not install it already by using plr_environ() in postgres. These are the few things I can think of. May be you have already tried them all..
Volkmar

Von: postgis-users-bounces at postgis.refractions.net<mailto:postgis-users-bounces at postgis.refractions.net> [mailto:postgis-users-bounces at postgis.refractions.net]<mailto:[mailto:postgis-users-bounces at postgis.refractions.net]> Im Auftrag von Darrel Maddy
Gesendet: Samstag, 28. Januar 2012 18:45
An: postgis-users at postgis.refractions.net<mailto:postgis-users at postgis.refractions.net>
Betreff: [postgis-users] Installation of PL/R

Apologies if this is not the right mail list for this but my confusion arises because of my 32 bit PostGIS install!

I have postgis2SVN sitting on top of postgresql 9.1 (32 bit) on a 64 bit version of windows (working fine).  I installed R-2.14.1 and tried to follow the instructions given here

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

Now I tried both the 32bit and 64bit dll from http://www.joeconway.com/plr/

I ran the sql script supplied but get  ERROR:  could not load library "C:/Program Files (x86)/PostgreSQL/9.1/lib/plr.dll": The specified procedure could not be found.

Needless to say plr.dll is in that location (I have tried both versions).

Any suggestions would be welcome (and apologies if this is a dumb question).

Thanks

Darrel


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120131/2d9cc266/attachment.html>