[postgis-users] Installation of PL/R

[Darrel Maddy]

Volkmar,

Many thanks for trying to help. Unfortunately I already did all of those things. To make matters worse I just tried the procedure on my 32bit windows system in my office and I am getting the same issue.  The dll is in the right place and the system variable and PATH are setup as per the instructions. I also checked that plr is not already installed.  I have stopped and restarted the PG service (including complete reboots) but to no avail.

Is this a problem with PG9.1?  Either that or I am systematically doing something wrong :( . The download site gives me the plr-8.3.0.13 zip from a link saying Win32 plr.dll for Postgres 9.0.x but above it includes 9.1 in the section title.

I will persevere as I would like to do analysis from within postgresql/postgis2 if at all possible.

Best wishes

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/20120130/3c5078d4/attachment.html>