<HTML dir=ltr><HEAD><TITLE>[postgis-users] postGIS install question- user permissions notaccepted by the DB</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText3355 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>It sounds like you are probably typing in the wrong password when prompted.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>If you go under Administrative Tools -> Users </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>find the postgres account</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>right-click - Set Password to something you know</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Then try reinstalling and giving it the password you set up.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Note there are 2 accounts - there is the windows account which the PostgreSQL service runs under</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>and the postgres account which is the postresql super user account which is used internally by Postgres (similar to sa account if you are familiar with SQL Server lingo). Don't confuse the 2.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I think the install asks you for both passwords and they are usually different.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV></DIV>
<DIV dir=ltr>Hope that helps,</DIV>
<DIV dir=ltr>Regina<BR></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of brooks.glenn@comcast.net<BR><B>Sent:</B> Mon 9/10/2007 1:47 PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] postGIS install question- user permissions notaccepted by the DB<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hi,<BR><BR>Sorry to bug you all with a simple question. <BR><BR>I have tried to re-install postgis into my postgres directory,( Window XP<BR>machine, Postgres 8x) but during the install routine I get the following error<BR>message:<BR><BR>"Could not connect to database postgres Password authentication failed for user<BR>postgres"<BR><BR>I previously uninstalled postgis and postgres because of an unrelated problem<BR>with another app and am now trying to reinstall functionality to use it with my<BR>GIS data and mapserver.<BR><BR>Can you advise me what to do?<BR><BR>thanks<BR><BR>Glenn Brooks<BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></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>