PostGIS extension for PostgreSQL

alexei_kasatkin's Avatar

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

    Feodor Fitsner's Avatar

    Will look into that!

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

    alexei_kasatkin's Avatar

    Any progress?
    Maybe is some beta environment?

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

    Feodor Fitsner's Avatar

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

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

    alexei_kasatkin's Avatar

    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/

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

    alexei_kasatkin's Avatar

    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

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

    Feodor Fitsner's Avatar

    Is PostGIS 2.2 bundle OK?

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

    alexei_kasatkin's Avatar

    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 ...`.

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

    alexei_kasatkin's Avatar

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

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

    sanak's Avatar

    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...

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac