[postgis-users] PostGIS Installation error using Stackbuilder

[Robert_Clift at doh.state.fl.us]

(NOTE: apparently Ctrl + Enter sends an outlook message -- woops)
 
Good morning Russell:
 
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 DB. As a disclaimer, I'm in a sandbox so I've
never considered potentially negative unintended consequences.
 
-Rob

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Russell Mercer
Sent: Thursday, June 14, 2012 10:20 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] PostGIS Installation error using Stackbuilder


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.

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.

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"

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.

I then tried to install PostGIS 1.5.3, with the same password fail
result.

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.

Thanks,
Russell

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120615/3eca7bef/attachment.html>