Regina,<br><br>Thanks for the response.<br><br>Having just installed PostgreSQL at the same time, I know that there are not multiple installations, so I don't think that is the culprit.<br><br>I think it may be a password issue. I don't have either of the characters you mentioned, however, have you done any testing with a password containing the percent (%) symbol?<br>
<br>I am not in the office today to test it, but on Monday I will try the workaround.<br><br>Thanks again!<br>Russell<br><br><div class="gmail_quote">On Fri, Jun 15, 2012 at 3:03 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Does your password have apostrophes in it? I think there
is an issue with ' and possibly spaces as well in passwords that is
on our todo to fix.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">One work around is change your pg_hba.conf temporarily to
trust for localhost, reload or restart the service </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">and then change it back to md5 when you are done
installing.</font></span></div></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Aside from that only thing I can think of is you are not
installing on the one you think you are. This happens if you have multiple
installations of PostgreSQL on different ports with different postgres super
user passwords.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Russell Mercer<br><b>Sent:</b> Thursday, June 14, 2012 10:20
PM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b>
[postgis-users] PostGIS Installation error using
Stackbuilder<br></font><br></div><div><div class="h5">
<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></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>