[postgis-users] PostGIS Installation error using Stackbuilder

[Paragon Corporation]

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.
 
One work around is change your pg_hba.conf temporarily to trust for
localhost, reload or restart the service 
and then change it back to md5 when you are done installing.
 
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.
 
 
Hope that helps,
Regina
http://www.postgis.us
 
 


  _____  

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/a9e0ad4c/attachment.html>