Remi, New workflow would be: 1) Copy the contents of the zip file to your PostgreSQL install -- the folders are laid out the same as standard PostgreSQL EDB so should just be copy over and overwrite if file is present. 2) Then use pgAdmin or psql to create a new database 3) Then use pgAdmin or psql to do (you can also use the Extension gui part in pgAdmin which shows all the extensions available that you can pick) CREATE EXTENSION postgis; CREATE EXTENSION pgrouting; CREATE EXTENSION address_standardizer; CREATE EXTENSION postgis_topology; (Create extension options packaged with windows are described at bottom of this page on right) http://postgis.net/windows_downloads Note: 2.2 development versions also include postgis_sfcgal extension. etc. in this new database. I thought I had removed the batch scripts from the zip packages, but I guess I only did it for the bundle one which I upload to osgeo and use to build the exes and the 2.2 binaries. The regular ones on winnie -- have the readme and the (2.1s have batch scripts though I stopped including batch script for 2.2). Anyway I'll make sure ot include the readme in the next bundle zip. I still need to finish off making the 2.1.4s but was going to wait till 9.4 comes out to finish the rest. and thanks for pointing out the confusion. It's easy to forget that things are unclear users when you have the steps memorized. Thanks, Regina http://www.postgis.us
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Rémi Cura Sent: Thursday, November 13, 2014 4:03 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] no .bat in windows zip installers Hello Regina, thanks for the answer. I'm not a big fan of bat files, but I do have to use the zip version and not the .exe. So maybe a small update of the README.txt to indicate how to get postgis working without the bat files. What we did is get the .bat from 2.1.1 and past it in the 2.1.2, then run it. Then we could use the CREATE EXTENSION on a fresh database. What would be the new workflow? Cheers, Rémi 2014-11-12 21:04 GMT+01:00 Paragon Corporation <[email protected]>: Remi, That was intentional. The main reason is that with windows systems being security paranoid, the copy would often fail and it would be hard to see looking at a batch script console. Also now that we have CREATE EXTENSION it was no longer an issue trying to find the scripts to run, which was the main reason for the batch script. Did you find it useful? If so I can put them back. Thanks, Regina http://www.postgis.us _____ From: [email protected] [mailto:[email protected]] On Behalf Of Rémi Cura Sent: Wednesday, November 12, 2014 11:41 AM To: PostGIS Users Discussion Subject: [postgis-users] no .bat in windows zip installers Hey everybody. The 2 bat files makepostgisdb_using_extensions.bat and makepostgisdb.bat seems to have vanished from the zip release file for version newer than 2.1.1 (postgis-bundle-pg93x64-2.1.1) I'm I missing something? thanks, cheers, Rémi-C _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
