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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zedler, Doug Sent: Wednesday, October 03, 2007 11:03 AM To: [email protected] 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.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
