<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16443">
<STYLE>@font-face {
font-family: Cambria;
}
@font-face {
font-family: Calibri;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>Ryan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>We tested them on 64-bit (windows 2008, 2008 R2, 2003,
and 7) so we know it works on all those. Admittedly we were mostly
focussed on 9.1 so we can't be absolutely sure we tested the 9.0 on
windows 2008 R2 (but we did on windows 7 64-bit). We were testing against
the EnterpriseDb distributed PostgreSQL's 64-bit so its possible ESRI compiled
their own and they require dependencies we left out since we assumed they were
present because EDB packages had them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>The most common culprit is the libxml2-2.dll
(though I thought we included that one in our last
packaging)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>You should check dependency walker to see what dependencies
you may be missing.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial><A
href="http://dependencywalker.com/">http://dependencywalker.com/</A> (use
the x64 one).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>Keep in mind the dependencies are in the bin of your
PostgreSQL install -- so you'll need to add that path in the dependency walker
add path for it to find them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><SPAN
class=324045921-14052012><FONT color=#0000ff size=2 face=Arial>Also make sure
the version of PostgreSQL you have is 64-bit. It's possible the ESRI cd only
comes with 32-bit in which case you should use the 32-bit 9.0 PostGIS
2.0. (even though you are running on a 64-bit
OS).</FONT></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>You can do a </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>SELECT version();</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>and it should have a 64-bit in there somewhere if you are
using 64-bit PostgreSQL. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>Let us know how it turns out.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=324045921-14052012><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=324045921-14052012><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>Timmons, Ryan P<BR><B>Sent:</B> Monday, May 14, 2012 5:53 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Installation problem on Windows Server 2008<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal>I am getting this error on the installation of Postgis
2.0.0 for Postgres 9.0 on a 64 bit windows server 2008 system, at the point
where it tries to make template_postgis_20:<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P
class=MsoNormal>psql:C:/CEMSA/PostgreSQL/9.0/share/contrib/postgis-2.0/postgis.sql:69:
ERROR: could not load library
"C:/CEMSA/PostgreSQL/9.0/lib/postgis-2.0.dll": The specified module could not
be found.<o:p></o:p></P>
<P class=MsoNormal><o:p></o:p></P>
<P class=MsoNormal>I checked the path and postgis-2.0.dll is indeed
there. I have retried a few times experimenting with permissions (even
temporarily promoting the “postgres” account to a machine administrator to
make sure it can read there), still getting same error.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>My postgres version is 9.0.5. We are aiming to
eventually combine this with ESRI’s ArcGIS Server/ArcSDE so used the postgres
installer from the ESRI CD. <o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I scanned the list archives after joining and found <A
href="http://postgis.refractions.net/pipermail/postgis-users/2012-May/033957.html">http://postgis.refractions.net/pipermail/postgis-users/2012-May/033957.html</A>
. The “should work on Windows XP” makes me wonder if Server 2008 is not
supported? The windows instructions (<A
href="http://postgis.refractions.net/download/windows/">http://postgis.refractions.net/download/windows/</A>)
talk about 32 vs. 64 bit, but no mention of XP vs. 7 vs. Server
etc.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Thanks in advance,<o:p></o:p></P>
<P class=MsoNormal>Ryan<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Cambria','serif'; FONT-SIZE: 12pt">Ryan
Timmons<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Cambria','serif'; FONT-SIZE: 12pt">Research Scientist,
O/A014S <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Cambria','serif'; FONT-SIZE: 12pt">Control Systems &
Information Sciences<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Cambria','serif'; FONT-SIZE: 12pt">Lockheed Martin
SSC<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Cambria','serif'; FONT-SIZE: 12pt">Cell:
248-895-1935<o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BLOCKQUOTE></BODY></HTML>