<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>