Home → Suggestions →

PostGIS extension for PostgreSQL

• Edit

alexei_kasatkin

06 Oct, 2014 11:48 AM

Thank you for providing awesome tool for Windows development!

PostGIS ( http://postgis.net/ )is a spatial database extension for PostgreSQL (adds geometry-related functions). It is very commonly used in
OpenStreetMap project software etc.

It would be great if you could add this module to current PostgreSQL installation (via checkbox in PostgreSQL Application Stack Builder or separate installer).

I planned to use it for osm2pgsql project testing: https://ci.appveyor.com/project/alex85k/osm2pgsql-cmake

If woul be perfect if you could also add small Python module psycopg2 for PostgreSQL communication
http://www.stickpeople.com/projects/python/win-psycopg :)

1. Support Staff 1 Posted by Feodor Fitsner on 06 Oct, 2014 08:50 PM

   

   Will look into that!

   • Edit

2. 2 Posted by alexei_kasatkin on 12 Nov, 2014 11:36 AM

   

   Any progress?
   Maybe is some beta environment?

   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 13 Nov, 2014 04:12 AM

   

   Sorry, didn't have a chance to look into that. Are there any instructions for how to install that extension to PG?

   • Edit

4. 4 Posted by alexei_kasatkin on 14 Nov, 2014 07:54 AM

   

   The instructions are simple - just run Application Stack Builder from Postgres and install Spatial Extensions -> PostGis 2.1 bundle (default settings will work)
   Creating demo db is optional, it may be done by applications to save HD space. You can also delete downloaded postgis archive from the home folder.

    https://db.tt/zkywJ2hw
    http://www.gpsfiledepot.com/tutorials/installing-and-setting-up-postgresql-with-postgis/
    http://gis.stackexchange.com/questions/41060/how-to-install-postgis-on-windows

   Installing psycopg2 is even easier - only choosing the installer for installed Python version is needed http://www.stickpeople.com/projects/python/win-psycopg/

   • Edit

5. 5 Posted by alexei_kasatkin on 18 Oct, 2015 01:53 PM

   

   Any chance this could be implemented?
   At least two important open-source map-related projects are hoping to run some small tests on Appveyour but have no needed extension...
   https://github.com/openstreetmap/osm2pgsql
   https://github.com/mapbox/tilemill/issues/2469

   • Edit

6. Support Staff 6 Posted by Feodor Fitsner on 21 Oct, 2015 07:21 PM

   

   Is PostGIS 2.2 bundle OK?

   • Edit

7. 7 Posted by alexei_kasatkin on 21 Oct, 2015 07:36 PM

   

   Yes, 2.2 will be quite fine!
   If possible, please also add Python access module Psycopg2 from here:
   http://www.stickpeople.com/projects/python/win-psycopg/
   (for installed 32/64 python versions) to reduce using of non-reliable and `pip install ...`.

   • Edit

8. 8 Posted by alexei_kasatkin on 22 Oct, 2015 04:34 PM

   

   The project to check if Posgis works: https://ci.appveyor.com/project/alex85k/osm2pgsql
   (missing functions are just from that)

   • Edit

9. 9 Posted by sanak on 19 Jun, 2016 04:36 AM

   

   Here is the workaround for installing PostGIS 2.2.2 to PostgreSQL 9.4.

   service:
     - postgresql94
   install:
     - curl -L -O -S -s http://winnie.postgis.net/download/windows/pg94/buildbot/postgis-pg94-binaries-2.2.2w64gcc48.zip
     - 7z x postgis-pg94-binaries-2.2.2w64gcc48.zip
     - xcopy /e /y /q postgis-pg94-binaries-2.2.2w64gcc48 C:\Progra~1\PostgreSQL\9.4
   :
   

   About PostgreSQL 9.5, there may be still the following issue.
   http://gis.stackexchange.com/questions/187581/could-not-load-librar...

   • Edit

10. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:06 AM.