[postgis-users] PostGIS Installation error using Stackbuilder

[Russell Mercer]

Regina,

Thanks for the response.

Having just installed PostgreSQL at the same time, I know that there are
not multiple installations, so I don't think that is the culprit.

I think it may be a password issue.  I don't have either of the characters
you mentioned, however, have you done any testing with a password
containing the percent (%) symbol?

I am not in the office today to test it, but on Monday I will try the
workaround.

Thanks again!
Russell

On Fri, Jun 15, 2012 at 3:03 AM, Paragon Corporation <lr at pcorp.us> wrote:

> **
> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120615/dfae2acc/attachment.html>