<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>PostGIS installer under Vista</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">We are getting set to migrate 20 PostgreSQL/PostGIS users from XP to Vista. In order to install any software on gov't vista computers we have to build "approved packages" to do the install. This sometimes means changing installation settings and adapting an installion to get around admin issues that we can't control.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I'm having trouble installing PostGIS 1.3.5 on a locked down BC gov't vista computer (restricted admin privileges). </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The installer fails at the create template database step, but seems to have copied files to:</FONT>
<BR> <FONT SIZE=2 FACE="Arial">C:\Program Files\PostgreSQL\8.3\bin etc.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I'm running the postgis_1_3_5_pg83.exe (as downloaded from the application stack builder) with only PostGIS selected for install.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">The original install of PostgreSQL 8.3 has to be run as administrator and can't initialize the data directory (initdb), so I'm trying to just get the software (both PostgreSQl and PostGIS) installed and then let a local user create the data directory and initialize the databases.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">In looking at the failed installation, it seems that a number of files have been copied over to the PostgreSQL directory. Does the installer do anything "special" besides copying files to:</FONT></P>
<P>
<BR><FONT SIZE=2 FACE="Courier New"> C:\Program Files\PostgreSQL\8.3\bin</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> some.dlls</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> C:\Program Files\PostgreSQL\8.3\jdbc</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> some.jar</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> C:\Program Files\PostgreSQL\8.3\lib</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> some.dlls</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> C:\Program Files\PostgreSQL\8.3\share\contrib</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> some.sqls</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> C:\Program Files\PostgreSQL\8.3\share\contrib\postgis</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> proj</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> topology</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> utils</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New"> Then create registry entries for</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> Computer\HKEY_LOCAL_MACHINE\SOFTWARE\PostGIS\1.3.5\PostgreSQl8.3</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> (default)</FONT>
<BR><FONT SIZE=2 FACE="Courier New"> Version</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">In other words can I simply copy the PostGis files over by hand (to an existing PostgreSQL install) and then add the 2 registry entries.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">My other option is to modify the installer to prevent it from trying to create the template database.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">It would be nice to have a checkbox in the installer that lets you delay the cration of the template database.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks!</FONT>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Comic Sans MS">Dave Waddell</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Comic Sans MS">BC Ministry of Forests</FONT></SPAN><SPAN LANG="en-ca"></SPAN>
</P>
</BODY>
</HTML>