[postgis-users] Installation Error

[Obe, Regina]

Doug,
 
Strange.  Not typing in the right password or typing in the password in
the wrong case is the only reason I can think why you would get the
below error.
 
As a work-around - what you could do (which I do anyway) is to set the
authentication to trust for localhost.  To do that do the following
 
1) You can do it from pgAdmin ->Tools -> Server configuration ->
pg_hba.conf   
and add or check the line that says 
 
host   all all 127.0.0.1/32  trust
 
Alternatively which sometimes I find easier - just open up the
pg_hba.conf file usually located in or wherever you chose to store your
data
 
C:\Program Files\PostgreSQL\8.2\data
 
and  make sure you have an uncommented line (comment is #) that reads
 
host    all         all         127.0.0.1/32          trust
 
Then restart your postgresql service from services manager.
 
When you install - as long as you type in a real account and you are
directly on the server, whatever password you type in will be ignored
and the connection will be trusted.
 
Hope that helps,
Regina
 
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Zedler, Doug
Sent: Wednesday, October 03, 2007 11:03 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Installation Error


I'm trying to install PostgreSQL and PostGIS to play with it and learn
about it.  I installed PostgreSQL 8.2.4 just fine.  I am able to connect
using pgAdmin III and such.  When I run the PostGIS 1.3.1 installation
executable, I get the following error:
 
createdb: could not connect to database postgres: FATAL:  password
authentication failed for user "postgres"
 
I am able to connect to the postgres database using pgAdmin III under
the postgres role using the same password I'm putting into the
installation wizard, and I'm not mixing up the password for the database
role with the password for the local account on my machine.  Any
suggestions are appreciated.
 
Thanks,
 

Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071004/d3330464/attachment.html>