[postgis-users] A question on PostGIS Cookbook

Stephen V. Mather svm at clevelandmetroparks.com
Wed Jul 16 20:31:49 PDT 2014

Hi Regina,

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




[http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)

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


Hope that helps,

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?


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

Oops "Hi Steve"


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

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

Hi Stephen,

This is the .exe:



And when you run it, I have this information:

"Packaged by EDB EnterpriseDB"

I have also pgadmin3 1.18.1.

Thanks for your help.


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

Hi Cyril,

Specifically, which installer did you use for PostgreSQL?


On Mon, Jul 14, 2014 at 4:23 AM, Paolo Corti <pcorti at gmail.com<mailto:pcorti at gmail.com>> wrote:
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
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

On Fri, Jul 11, 2014 at 6:51 PM, Cyril Poitevin
<cyril.poitevin at univ-lr.fr<mailto: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<mailto: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/20140717/af2ae602/attachment.html>

More information about the postgis-users mailing list