[postgis-users] Combined Windows version of PostGIS/P-LR
TECHER David
davidtecher at yahoo.fr
Mon Jun 18 15:15:47 PDT 2007
Mike Leahy a écrit :
> Hey all,
>
> I'm just wondering if this thread should move back to the plr-general
> list. In particular, I think it would be good if Joe is able to add a
> link to the installer on the PL/R web page. I just tried the installer,
> and it works great - nice work David.
>
> I did notice, however, that it claims to be installing PgRouting in the
> welcome screen, and it appears as PgRouting in the Windows uninstall
> list.
Well I did the installer, last Saturday night and I was hurry.
You know when you haven't slept all a night, you don't see errors
thanks.
> Also, I think more than is needed is being added to the Path
> variable. In my case, this is what gets added after the installer is done:
>
> "\;C:\Program Files\R\R-2.5.0\bin;C:\Program
> Files\PostgreSQL\8.2\bin;C:\Program Files\PostgreSQL\8.2\lib"
>
>
I reduced it to
\;C:\Program Files\R\R-2.5.0\bin
> When I had installed PL/R manually, I seemed to be able to get away with
> adding just ";C:\Program Files\R\R-2.5.0\bin".
Yes it is, you're right. But if you use a function like
select load_r_typenames();
pl/r needs to know what it you R_HOME environment variable.
> Also, if I happen to
> re-install PL/R, the entire string above will appear multiple times in
> the Path variable. Is it possible for the installer to check for that?
>
>
I've only been able to detect if R directory is present in PATH variable
for the moment!
Not able to remove it for the moment from a previous install
If you want, my Inno Setup script is available at
http://www.davidgis.fr/download/plr-8.2.0.4-win32-src.zip
If someone is used here to using Inno SetUp, no problem to improve it.
> Regards,
> Mike
>
> TECHER David wrote:
>
>> Hi Regina,
>>
>> Many thanks for these interesting link! Very excellent!
>>
>> I will wait for the next series of your articles!
>>
>> --david;
>>
>> Obe, Regina a écrit :
>>
>>> Since Dave was doing his part, I figured I would help out the cause a
>>> little. R is pretty new to me too but looks like it could be very useful.
>>> I drafted up a quick getting started and included David's link in there.
>>> http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01
>>>
>>> Let me know any parts that seem unclear or where I went wrong. The
>>> steps seemed to work for me.
>>> Thanks,
>>> Regina
>>>
>>> ------------------------------------------------------------------------
>>> *From:* postgis-users-bounces at postgis.refractions.net on behalf of
>>> TECHER David
>>> *Sent:* Sun 6/17/2007 2:53 AM
>>> *To:* PostGIS Users Discussion
>>> *Subject:* Re: [postgis-users] Combined Windows version of PostGIS/P-LR
>>>
>>> Dear Jan,
>>>
>>> I begun to use PL/R. As you know, I'm not a expert in R
>>>
>>> Compiling with PostgreSQL 8.2.4 on win32 ...no problem!
>>>
>>>
>>> These release is available at
>>>
>>> http://www.davidgis.fr/download/plr-8.2.0.4_0_win32.exe
>>>
>>> I've tryed to see here if
>>>
>>> first R 2.5.0 is available on the computer where you want to install it.
>>>
>>> else it stop!
>>>
>>> The installer updates the R_HOME environment variable
>>> and update the PATH in order to adding 'R_HOME'/bin directory
>>>
>>> Let me know if it works for you
>>>
>>> createdb testR
>>>
>>> psql -d testR -f / "path/to/your/postgresql/dir"/share/contrib/plr.sql
>>>
>>> psql testR
>>>
>>> select load_r_modules();
>>>
>>> select * from plr_environ();
>>>
>>> and so on
>>>
>>> --david;
>>>
>>> Jan Hartmann a écrit :
>>>
>>>> I agree. A separate installer for PL/R would be the first thing to
>>>> create. Am I right that that would not be very difficult? After that,
>>>> though, I would very much like to have a *combined* version, with PL/R
>>>> and PostGIS both enabled. I am not sure how difficult that would be,
>>>> but, as I said, it would be a marvelous example of Open Source
>>>> software cooperation. The additional packages Mike mentioned don't
>>>> have to be installed prior to installing PL/R; you can install them in
>>>> the regular way in R (R INSTALL), and an existing PostgreSQL database
>>>> with PL/R will recognise them after a restart.
>>>>
>>>> BTW: deldir was a major reason for me to experimnt with a combined
>>>> version: the power of voronoi diagrams in a PostGIS database!
>>>>
>>>> Jan
>>>>
>>>> Mike Leahy wrote:
>>>>
>>>>> David/Jan:
>>>>>
>>>>> Although PostGIS and PL/R can be complimentary tools, I think a
>>>>>
>>> separate
>>>
>>>>> installer (for now at least) would make the most sense for PL/R. At
>>>>> least that way there is still the option for other users to install
>>>>>
>>> PL/R
>>>
>>>>> without PostGIS, and vice-versa.
>>>>>
>>>>> At the same time, however, I can see how a including PL/R as an option
>>>>> in the PostGIS installer could be useful - particularly if a set of
>>>>> pre-defined functions were included with the setup that made use of
>>>>>
>>> PL/R
>>>
>>>>> for spatial statistical operations within PostGIS. But this might
>>>>>
>>> get a
>>>
>>>>> bit complicated, considering the requirements involved (e.g., having R
>>>>> installed, as well as packages installed in R - such as deldir for
>>>>> making voronoi polygons).
>>>>>
>>>>> Mike
>>>>>
>>>>> TECHER David wrote:
>>>>>
>>>>>> Hi Jan,
>>>>>>
>>>>>> Before I made a mistake, all you want is only a win32-installer for
>>>>>> PL/R?
>>>>>>
>>>>>> because I think you know that's postgis win32-installer already
>>>>>>
>>> exist?
>>>
>>>>>> See http://www.postgis.org/download/windows/
>>>>>>
>>>>>> --david;
>>>>>>
>>>>>>
>>>>>> Jan Hartmann a écrit :
>>>>>>
>>>>>>> Hi folks (sorry for crossposting),
>>>>>>>
>>>>>>> Joe Conway just announced that PL/R will soon be available for
>>>>>>> Windows. See the thread starting at:
>>>>>>>
>>>>>>>
>>>>>>>
>>> http://gborg.postgresql.org/pipermail/plr-general/2007-June/000235.html
>>>
>>>>>>> PL/R is an implementation of the statistical package R within
>>>>>>> PostgreSQL. See:
>>>>>>>
>>>>>>> http://www.joeconway.com/plr/
>>>>>>> http://www.r-project.org <http://www.r-project.org/>
>>>>>>>
>>>>>>> It's installed the same way as postGIS, but until now only a Linux
>>>>>>> version was available. I have them both enabled on my server at SARA
>>>>>>> computing center, and the functionality is unbelievable. My own
>>>>>>> organisation, however, doesn't allow me to install Linux servers,
>>>>>>>
>>> and
>>>
>>>>>>> even if they did, neither staff nor students would be willing or
>>>>>>>
>>> even
>>>
>>>>>>> able to work with them. I guess this is not a unique situation, so
>>>>>>> this Windows port is really important. Moreover, a PostgreSQl
>>>>>>> implementation with full GIS and statistical functionality is
>>>>>>> something that doesn't exist in the commercial world as far as I
>>>>>>>
>>> know.
>>>
>>>>>>> An easy installable Windows version would IMO really be a showpiece
>>>>>>> for Open Source software. I would really appreciate if people in the
>>>>>>> know on both these lists would put their heads together to implement
>>>>>>> this. I don't really know much about Windows installers, but my
>>>>>>> feeling is that it is not enormously difficult.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Jan Hartmann
>>>>>>>
>>>>>>> Dr. J. Hartmann
>>>>>>> Department of Geography
>>>>>>> University of Amsterdam
>>>>>>> _______________________________________________
>>>>>>> postgis-users mailing list
>>>>>>> postgis-users at postgis.refractions.net
>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>> ___________________________________________________________________________
>>>
>>>
>>>>>> Yahoo! Mail r?invente le mail ! D?couvrez le nouveau Yahoo! Mail
>>>>>>
>>> et son
>>>
>>>>>> interface r?volutionnaire.
>>>>>> http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/>
>>>>>> _______________________________________________
>>>>>> postgis-users mailing list
>>>>>> postgis-users at postgis.refractions.net
>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>
>>>>>>
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>
>>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>>>
>>>
>>>
>>>
>>>
>>> ___________________________________________________________________________
>>>
>>> Yahoo! Mail rinvente le mail ! Dcouvrez le nouveau Yahoo! Mail et son
>>> interface rvolutionnaire.
>>> http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>> ------------------------------------------------------------------------
>>>
>>> *The substance of this message, including any attachments, may be
>>> confidential, legally privileged and/or exempt from disclosure
>>> pursuant to Massachusetts law. It is intended solely for the
>>> addressee. If you received this in error, please contact the sender
>>> and delete the material from any computer. *
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>
>>
>>
>>
>> ___________________________________________________________________________
>> Yahoo! Mail r?invente le mail ! D?couvrez le nouveau Yahoo! Mail et son
>> interface r?volutionnaire.
>> http://fr.mail.yahoo.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
___________________________________________________________________________
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com
More information about the postgis-users
mailing list