<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2>Regina,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2>I have a password manager, so each time I enter the
password (in pgAdmin or in the PostGIS installation wizard), I copy it from the
password manager. Maybe the wizard has a problem with pasting the password
in.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2>Your work around worked. It seems to have installed
successfully. So, you always have trust authentication for
localhost? Does that mean anyone logging on to this computer has full
access to the database?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=297522414-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">Douglas
B. Zedler<o:p></o:p></SPAN></DIV>
<DIV align=left>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">IT
Programmer/Analyst<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">Fort
Worth Fire Department<o:p></o:p></SPAN></P><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">817.392.8463</SPAN></DIV>
<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>Obe,
Regina<BR><B>Sent:</B> Thursday, October 04, 2007 9:16 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> RE: [postgis-users] Installation
Error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>Doug,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>Strange. Not typing in the right password or typing
in the password in the wrong case is the only reason I can think why you would
get the below error.</FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff size=2>As a
work-around - what you could do (which I do anyway) is to set the authentication
to trust for localhost. To do that do the following</FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff size=2>1) You
can do it from pgAdmin ->Tools -> Server configuration ->
pg_hba.conf </FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff size=2>and
add or check the line that says </FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2>host all all 127.0.0.1/32 trust</FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2>Alternatively which sometimes I find easier - just open up the
pg_hba.conf file usually located in or wherever you chose to store your
data</FONT></SPAN></DIV>
<DIV><SPAN class=370370114-04102007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2>C:\Program
Files\PostgreSQL\8.2\data</FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>and make sure you have an uncommented line (comment
is #) that reads</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>host
all
all
127.0.0.1/32
trust</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>Then restart your postgresql service from services
manager.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>When you install - as long as you type in a real account
and you are directly on the server, whatever password you type in will be
ignored and the connection will be trusted.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=370370114-04102007><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV dir=ltr align=left><BR></DIV>
<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>Zedler, Doug<BR><B>Sent:</B> Wednesday, October 03, 2007 11:03
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Installation Error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=080155514-03102007><FONT face=Arial size=2>I'm trying to
install PostgreSQL and PostGIS to play with it and learn about it. I
installed PostgreSQL 8.2.4 just fine. I am able to connect using pgAdmin
III and such. When I run the PostGIS 1.3.1 installation executable, I get
the following error:</FONT></SPAN></DIV>
<DIV><SPAN class=080155514-03102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=080155514-03102007><FONT face=Arial size=2></FONT></SPAN><SPAN
class=080155514-03102007><FONT size=2><FONT face=Arial>createdb: could not
connect to database postgres: FATAL: password authentication failed for
user "postgres"</FONT></DIV></FONT></SPAN>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=080155514-03102007>I am able to connect
to the postgres database using pgAdmin III under the postgres role using the
same password I'm putting into the installation wizard, and I'm not mixing up
the password for the database role with the password for the local account on my
machine. Any suggestions are appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=080155514-03102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=080155514-03102007>Thanks,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">Douglas
B. Zedler<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">IT
Programmer/Analyst<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma">Fort
Worth Fire Department<o:p></o:p></SPAN></P><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Bookman Old Style'; mso-bidi-font-family: Tahoma; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">817.392.8463</SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant to
Massachusetts law. It is intended solely for the addressee. If you received this
in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>