<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.17148"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>Remi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>New workflow would be:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>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 class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>2) Then use pgAdmin or psql to create a new
database</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>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 class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>CREATE EXTENSION postgis;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>CREATE EXTENSION pgrouting;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>CREATE EXTENSION address_standardizer;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>CREATE EXTENSION postgis_topology;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>(Create extension options packaged with windows are described
at bottom of this page on right)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/windows_downloads">http://postgis.net/windows_downloads</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>Note: 2.2 development versions also include postgis_sfcgal
extension.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>etc.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>in this new database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>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 class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>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 class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>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 class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=394162109-13112014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Rémi
Cura<BR><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>
<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 color=#0000ff
face=Arial>Remi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>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 color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>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 color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>Did you find it
useful? If so I can put them back.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial><A
href="http://www.postgis.us"
target=_blank>http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us dir=ltr 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 class=h5>
<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">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></BODY></HTML>