<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16434"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>Arto,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>You can't use postgresql 9.1.1-windows with
postgis-pg90-binaries-1.5.3. zip. Those are
incompatible.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>We have builds for upcoming PostGIS 2.0 for PostgreSQL 9.1
windows which will work together. In the experimental
section:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/download/windows/experimental.php#PostGIS_2_0_0">http://www.postgis.org/download/windows/experimental.php#PostGIS_2_0_0</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>We were hoping that PostGIS 2.0 would be released before
PostgreSQL 9.1 so that we wouldn't have to produce PostGIS 1.5 binaries for
PostgreSQL 9.1. given that that</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>didn't happen and PostGIS 2.0 will be months from now, I guess
we'll need to produce 1.5.3 binaries :(.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>If you can wait till this weekend or Monday, we should have
new batches of binaries ready for 1.5.3 (Pg 9.1) and PostGIS 2.0 (Pg
9.1).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>The PostGIS 2.0 -- next batch we release which we hope to do
in the next day or so will include the new KNN GIST support for
9.1</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>and new raster / raster intersects
functions.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>or you can stay on the stable less fun side and wait till this
weekend or Monday for us to prepare the 1.5.3 (Pg 9.1
builds).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>-- Regarding:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT size=2
face=Arial><FONT color=#0000ff>"</FONT><SPAN style="mso-ansi-language: EN-GB"
lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#0000ff>5) Just wondering: to create a PostGIS enabled database, is the
makepostgisdb.bat usage a must? Last year at least it was possible to use
PostGIS template in PgAdmin III to create a new database.<SPAN
class=015265709-28092011>"</SPAN></FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT size=2
face=Arial><SPAN style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#0000ff><SPAN
class=015265709-28092011></SPAN></FONT></SPAN></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT size=2
face=Arial><SPAN style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#0000ff><SPAN class=015265709-28092011>The makepostgisdb.bat can make a
template database for you. You just have to change the variables in there
and unremark out the update template
line.</SPAN></FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><FONT color=#0000ff
size=2 face=Arial>Regina and Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015265709-28092011><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=015265709-28092011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Arto Vuorela<BR><B>Sent:</B> Wednesday, September 28, 2011 5:48
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] PostGIS installation in Windows 32-bit<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">Hello</SPAN></DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"></SPAN> </DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">I
aim to use postgresql-9.1.1-1-windows.exe and postgis-pg90-binaries-1.5.3.zip
(aiming to use with <SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">zigGIS,
PgMap or ArcGIS 10.1, map service)</SPAN>. Some basic questions for
Windows Server 2003 installation:</SPAN></DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"></SPAN> </DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">1)
<SPAN style="mso-ansi-language: EN-GB" lang=EN-GB>PostGIS manuals say “A
complete installation of PostgreSQL (including <STRONG>server
headers</STRONG>) is required.” Were the server headers automatically
installed? I chose <SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: EN-GB; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=EN-GB>PgOleDB, <SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: EN-GB; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=EN-GB>pgJDBC and </SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FR; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=FR>psqlODBC database drivers for PostgreSQL, if that
matters.</SPAN></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: EN-GB; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=EN-GB></SPAN></SPAN></SPAN> </DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: EN-GB; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=EN-GB>2) Should I worry also about this (from the manual as well)?:
<P style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"
class=MsoNormal><SPAN
style="FONT-FAMILY: NimbusSanL-Regu; FONT-SIZE: 9pt; mso-ansi-language: EN-GB; mso-bidi-font-family: NimbusSanL-Regu"
lang=EN-GB>For GEOS functionality, when you install PostgresSQL you may need
to <STRONG>explicitly link PostgreSQL against the standard
</STRONG></SPAN><SPAN
style="FONT-FAMILY: NimbusSanL-Regu; FONT-SIZE: 9pt; mso-bidi-font-family: NimbusSanL-Regu"><STRONG>C++
library</STRONG>:</SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="FONT-FAMILY: NimbusMonL-Regu; FONT-SIZE: 9pt; mso-ansi-language: EN-GB; mso-bidi-font-family: NimbusMonL-Regu"
lang=EN-GB>LDFLAGS=-lstdc++ ./configure [YOUR OPTIONS HERE]</SPAN><SPAN
style="mso-ansi-language: EN-GB"
lang=EN-GB></SPAN></P></SPAN></SPAN></SPAN></DIV>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB>3) <SPAN
style="FONT-FAMILY: Verdana; COLOR: #555555; FONT-SIZE: 9pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'"><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#000000><STRONG>PostGIS JDBC driver</STRONG> I understand to
be different from PostgreSQL JDBC driver. <A
href="http://postgis.refractions.net/pipermail/postgis-devel/2006-November/002375.html"><FONT
color=#606420>http://postgis.refractions.net/pipermail/postgis-devel/2006-November/002375.html</FONT></A> <FONT
style="BACKGROUND-COLOR: #ffffff">says</FONT><FONT
style="BACKGROUND-COLOR: #ffffff"> <SPAN
style="BACKGROUND: yellow; mso-ansi-language: EN-GB; mso-highlight: yellow"
lang=EN-GB><FONT size=2><FONT face=Courier><FONT
style="BACKGROUND-COLOR: #ffffff">Versions 1.1.5 and 1.1.6 of the
PostGIS-JDBC-Drivers are available at</FONT><FONT
style="BACKGROUND-COLOR: #ffffff">
</FONT></FONT></FONT></SPAN></FONT></FONT></SPAN></SPAN></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman'; BACKGROUND: yellow; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-highlight: yellow"><A
href="http://lists.refractions.net/m2/org/postgis"><FONT
style="BACKGROUND-COLOR: #ffffff"
color=#606420>http://lists.refractions.net/m2/org/postgis</FONT></A><FONT
style="BACKGROUND-COLOR: #ffffff">. Someone also mentioned in discussions
that he found <SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: EN-GB; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang=EN-GB><EM>postgis-jdbc 1.3.5 on public Maven repositories.
</EM></SPAN>What is Maven or Pom I don't even know. Those all may be old
- should I use the non-debug jar version at JDBC SNAPSHOT on
page <A
href="http://postgis.refractions.net/download/">http://postgis.refractions.net/download/</A>?
Where should the chosen version be installed, or
h</FONT></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
style="BACKGROUND-COLOR: #ffffff">ow? By merely listing it in CLASSPATH
variable, as the <SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#000000>PostgreSQL JDBC driver? The PostGIS's README.txt does not tell
such things.</FONT></SPAN></FONT></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB><FONT
style="BACKGROUND-COLOR: #ffffff"></FONT></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB>4) As PostGIS is not found under
Stack Builder yet for 9.1, I should put the binaries in correct places. Are
the postgis-pg90-binaries-1.5.3 contents put in the installation folder
(...\<SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><FONT
color=#000000>PostgreSQL\9.1\, so that most files go under the three
subfolders)? The README.txt does not tell this
either.</FONT></SPAN></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"></SPAN></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt; mso-fareast-font-family: SimSun; mso-ansi-language: FI; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">5)
Just wondering: to create a PostGIS enabled database, is the makepostgisdb.bat
usage a must? Last year at least it was possible to use PostGIS template in
PgAdmin III to create a new database.</SPAN></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB" lang=EN-GB></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="mso-ansi-language: EN-GB"
lang=EN-GB>Arto</SPAN></P></BLOCKQUOTE></BODY></HTML>