PostGIS extension for PostgreSQL
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 :)
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
Support Staff 1 Posted by Feodor Fitsner on 06 Oct, 2014 08:50 PM
Will look into that!
2 Posted by alexei_kasatkin on 12 Nov, 2014 11:36 AM
Any progress?
Maybe is some beta environment?
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?
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/
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
Support Staff 6 Posted by Feodor Fitsner on 21 Oct, 2015 07:21 PM
Is
PostGIS 2.2 bundle
OK?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 ...`.
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)
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.
About PostgreSQL 9.5, there may be still the following issue.
http://gis.stackexchange.com/questions/187581/could-not-load-librar...
Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:06 AM.