[postgis-users] A question on PostGIS Cookbook

[Paragon Corporation]

Not that I know of.  I'm not sure why they bother including the extension
files for plpython2 but not the dll.  A bit confusing.

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Stephen V.
Mather
Sent: Wednesday, July 16, 2014 11:32 PM
To: 'PostGIS Users Discussion'; 'CyrilPoitevin'
Subject: Re: [postgis-users] A question on PostGIS Cookbook



Hi Regina,




Are there 9.3 versions compiled by others for Windows that are compiled with
Python 2?




Thanks,


Best,

Steve





 http://sig.cmparks.net/cmp-ms-90x122.pngStephen V. Mather
GIS Manager
(216) 635-3243 (Work)  <http://www.clemetparks.com> 
clevelandmetroparks.com




  _____  

From: postgis-users-bounces at lists.osgeo.org
<postgis-users-bounces at lists.osgeo.org> on behalf of Paragon Corporation
<lr at pcorp.us>
Sent: Wednesday, July 16, 2014 11:28 PM
To: 'PostGIS Users Discussion'; 'Cyril Poitevin'
Subject: Re: [postgis-users] A question on PostGIS Cookbook 
 
Regarding the Python versions for windows
 
For PostgreSQL 9.2+ EDB only supports plpython3u
 
If you are running 9.2 or 9.3 then you need to install Python 3.2
 
For 9.4 it looks like they built plpthon with Python 3.3
Also make sure if you installed 32-bit PostgreSQL you use the 32-bit Python
and if you installed PostgreSQL 64-bit you install the 64-bit python.
 
If you use a Python3 higher than what PostgreSQL is compiled with, it won't
work.
 
When in doubt, use dependency walker and open up the plpython3.dll and it
will tell you the version of Python you need
 
http://www.dependencywalker.com/
 
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
 


  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Stephen Mather
Sent: Wednesday, July 16, 2014 10:44 PM
To: Cyril Poitevin
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] A question on PostGIS Cookbook


No worries Cyril,

Formality always appreciated.

Try this for me-- try the "WinnieBot" installs from
http://postgis.net/windows_downloads .  I'm working on the assumption you
are not working (yet) toward a production version. The ones at this
location: http://winnie.postgis.net/download/windows/pg94/buildbot/ will
also allow you to use all the SFCGAL goodness of the 3D chapter.

I'm also cc'ing the postgis users group.

Hi all-- best suggestions for Windows PostGIS installs with 2.x Python? Have
the EDB versions of Postgres switched to 3.x Python?

Thanks,
Best,
Steve







On Tue, Jul 15, 2014 at 4:33 AM, Cyril Poitevin <cyril.poitevin at univ-lr.fr>
wrote:




Oops "Hi Steve"

Sorry.

-------- Message original --------

Objet:	 Re: A question on PostGIS Cookbook	
Date:	 15.07.2014 10:08	
De:	 Cyril Poitevin <cyril.poitevin at univ-lr.fr>	
À:	 Stephen Mather <stephen at smathermather.com>	

 

Hi Stephen,

This is the .exe:

postgresql-9.3.3-1-windows-x64.exe

https://www.sendspace.com/file/6eabi9

And when you run it, I have this information:

"Packaged by EDB EnterpriseDB"

I have also pgadmin3 1.18.1.

Thanks for your help.

Cyril

Le 15.07.2014 00:56, Stephen Mather a écrit :

Hi Cyril,


Specifically, which installer did you use for PostgreSQL?


Best,
Steve





On Mon, Jul 14, 2014 at 4:23 AM, Paolo Corti <pcorti at gmail.com> wrote:


Hi
as far as I can remember, on debian/ubuntu PostgreSQL has support for
bot Python 2.x and Python 3.x. Not being a Windows user I am not
totally sure what is the situation there.
The default, though, according to the documentation
(http://www.postgresql.org/docs/9.3/static/plpython-python23.html)
should be Python 2.x for any operating system:

"The language named plpythonu implements PL/Python based on the
default Python language variant, which is currently Python 2. (This
default is independent of what any local Python installations might
consider to be their "default", for example, what /usr/bin/python
might be.) The default will probably be changed to Python 3 in a
distant future release of PostgreSQL, depending on the progress of the
migration to Python 3 in the Python community."

Now, having said this, I am not sure why on your windows box the default is
3.2.
Maybe is it just a matter of installing the correct language name on
your database (plpython2u instead than plpython3u)?

I am adding Steve in copy, as he is the author of the Voronoi recipes
and maybe he has some more suggestions
regards
p

On Fri, Jul 11, 2014 at 6:51 PM, Cyril Poitevin
<cyril.poitevin at univ-lr.fr> wrote:
> Ciao,
>
> I've purchased PostGIS "Cookbook" last february, and it is really pleasant
> to read. I learned a lot with it. Thanks to bring a good reference book
like
> this for all the geomaticians.
>
> By the way, I have a problem that I can't solve for the moment, I can't
> reproduce the tutorial to calculate a voronoi diagram, I need this method
in
> my actual job, so it's quite important.
>
> I know you are not the author of this chapter but maybe you will be able
to
> help me or just redirect myself towards the author of this part.
>
> In PostgreSQL 9.3 Windows 64 package, there is no library for linking
> PostgreSQL to Python 2, only one library to link it with Python 3.2 and It
> seems all the source code necessary (from geogeek blog or pyhull) have
been
> developed with Python 2.7 so I can't use them. I tried to convert the code
> from geogeek blog for Python 3 but no success for the moment.
>
> You precise at the beginning of the book to install the latest version of
> PostgreSQL (9.3) so maybe you have a solution for using Python 2.7 with
> PostgreSQL 9.3,  I don't find solution on internet for that problem.
>
> Thanks in advance for your help.
>
> Kind regards.
>
> Cyril Poitevin - Ingénieur d'étude en traitement de données
> Mail : cyril.poitevin at univ-lr.fr / Tel : 06 03 48 77 34
> UMR 7266 / Littoral Environnement et Sociétés (LIENSs)
> 2 rue Olympe de Gouges 17000 La Rochelle



--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti


 


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