<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi, I just found a problem with the Postgis 1.5 installation on a
Windows Server 2008 64 bit platform,<br>
<br>
When I installed postgres, it requested a more "secure" password for
user 'postgres', maybe because this is a policy on WinServer2008, and I used a
combination of special chars, something like 'my00%$password&'<br>
<br>
Postgres accepted it very well, but the installation of postgis
didn't. Not postgis 1.4, nor 1.5, not on postgres 8.3, 8.3.7, 8.4.3.
I kept installing different options and watching them fail.<br>
<br>
The postgis installation kept failing, with an error 'password is
incorrect for user postgres', even when I edited pg_hba.conf to make it
trust 127.0.0.1<br>
<br>
The problem got worse, because when the postgis installation failed,
some process was left behind, and next installation could fail on a
different part of the installation.<br>
<br>
Workaround? I added another postgres user, as a superuser, granted
everything. I didn't give this user special chars in the password, and
I installed postgis with this user.<br>
<br>
It worked flawlesly. End of the problem.<br>
<br>
<br>
<br>
I'm writing just to let you know, in case it helps someone else or
someone can upload it to the bug list to get corrected. If a password
is accepted on postgres, should be accepted on a postgis installation.<br>
<br>
Best regards.<br>
<br>
John Lace <br> <br /><hr /> <a href='' target='_new'></a></body>
</html>