<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.21312" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial
color=#0000ff size=2><SPAN class=673193314-15062012>(NOTE: apparently Ctrl +
Enter sends an outlook message -- woops)</SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial
color=#0000ff size=2>Good morning Russell:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial><FONT
color=#0000ff><FONT size=2>I've had several password authentication problems on
Windows (XP though, not Server 08) specifically when connecting via command
line. I worked around it by creating a Windows user account with the same name
and password as my role on the<SPAN class=673193314-15062012> DB. As a
disclaimer, I'm in a sandbox so I've never considered potentially negative
unintended consequences.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=673193314-15062012></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=494545413-15062012><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=673193314-15062012>-Rob</SPAN></FONT></FONT></FONT></SPAN></DIV></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Russell Mercer<BR><B>Sent:</B> Thursday, June 14, 2012 10:20
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] PostGIS Installation error using
Stackbuilder<BR></FONT><BR></DIV>
<DIV></DIV>I am trying to install PostGIS on Postgresql 9.1 using the
Stackbuilder program. Postgresql 9.1 was installed using the 1 click
installer from EnterpriseDB.<BR><BR>Postgres installed completely, so I
initiated the install for PostGIS. I selected PostGIS 2.0, entered my
password for the "postgres" user at the prompt and started the
install.<BR><BR>The install made it almost to the end, and failed with the
following error: createdb: could not connect to database postgres:
FATAL: password authentication failed for user "postgres"<BR><BR>I was
concerned that I entered the wrong password at the prompt, so I opened up
pgAdmin III to test. I was able to log in using the "postgres" user name
and the password with no issues.<BR><BR>I then tried to install PostGIS 1.5.3,
with the same password fail result.<BR><BR>Can anyone give me some insight into
what I am doing wrong? I am installing onto a server with Windows Server
2008 Service Pack 2.<BR><BR>Thanks,<BR>Russell<BR></BODY></HTML>