<div dir="ltr"><div><div>No problem,<br>in fact I build my postgis on my ubuntu so I'm not familiar with windows folder tree, but a colleague needed it on windows so ...<br></div>Cheers,<br></div>Rémi-C<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-13 10:36 GMT+01:00 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Remi,</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">New workflow would be:</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">2) Then use pgAdmin or psql to create a new
database</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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)</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">CREATE EXTENSION postgis;</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">CREATE EXTENSION pgrouting;</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">CREATE EXTENSION address_standardizer;</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">CREATE EXTENSION postgis_topology;</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">(Create extension options packaged with windows are described
at bottom of this page on right)</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"><a href="http://postgis.net/windows_downloads" target="_blank">http://postgis.net/windows_downloads</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Note: 2.2 development versions also include postgis_sfcgal
extension.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">etc.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">in this new database.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">and thanks for pointing out the confusion. It's easy to
forget that things are unclear users when you have the steps
memorized.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Regina</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><span class=""><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Rémi
Cura<br></span><b>Sent:</b> Thursday, November 13, 2014 4:03 AM<br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> Re: [postgis-users] no .bat in windows zip
installers<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>Hello Regina,<br></div>
<div>thanks for the answer.<br><br></div>I'm not a big fan of bat files,<br>but
I do have to use the zip version and not the .exe.<br></div></div>So maybe a
small update of the README.txt to indicate<br>how to get postgis working without
the bat files.<br><br></div>What we did is get the .bat from 2.1.1 and past it
in the 2.1.2, then run it.<br></div>Then we could use the CREATE EXTENSION on a
fresh database.<br><br></div>What would be the new
workflow?<br><br></div>Cheers,<br>Rémi<br></div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-11-12 21:04 GMT+01:00 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span>:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT:1ex;MARGIN:0px 0px 0px 0.8ex;BORDER-LEFT:#ccc 1px solid"><u></u>
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Remi,</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">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.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Did you find it
useful? If so I can put them back.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">Regina</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font></span> </div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Rémi Cura<br><b>Sent:</b> Wednesday, November 12, 2014 11:41
AM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> [postgis-users]
no .bat in windows zip installers<br></font><br></div>
<div>
<div>
<div></div>
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>Hey everybody.<br></div>The 2 bat
files<br>makepostgisdb_using_extensions.bat<br></div>and<br>makepostgisdb.bat<br><br></div>seems
to have vanished from the zip release file for version newer than 2.1.1
(postgis-bundle-pg93x64-2.1.1)<br><br></div>I'm I missing
something?<br></div>thanks,<br></div>cheers,<br></div>Rémi-C<br>
<div>
<div>
<div>
<div><br></div></div></div></div></div></div></div></div><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>