[postgis-users] PostGIS Installation error using Stackbuilder

[Russell Mercer]

Regina,

I wanted to put put there the solution that I found to my problem:  I
changed my the password for the postgres user in pgadmin III to one that
did not have any special characters in it, specifically, no % sign.

After this, I ran the PostGIS installer again, and it completed with no
problems at all.

You may want to add this to your todo list as well.

Thanks for at least pointing me in the right direction regarding special
characters.

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/20120618/89cc2281/attachment.html>