Thanks for the help and the info. Douglas B. Zedler
IT Programmer/Analyst Fort Worth Fire Department 817.392.8463 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Obe, Regina Sent: Thursday, October 04, 2007 9:41 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] Installation Error Yes anyone logging on to this computer has full access to the database. For me it isn't too much of a concern since I manage the servers I have and for development I'm not too concerned about people I don't know logging into my computer. If you are concerned about it, you can always switch the setting back. Thanks, Regina ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zedler, Doug Sent: Thursday, October 04, 2007 10:34 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] Installation Error Regina, I have a password manager, so each time I enter the password (in pgAdmin or in the PostGIS installation wizard), I copy it from the password manager. Maybe the wizard has a problem with pasting the password in. Your work around worked. It seems to have installed successfully. So, you always have trust authentication for localhost? Does that mean anyone logging on to this computer has full access to the database? Douglas B. Zedler IT Programmer/Analyst Fort Worth Fire Department 817.392.8463 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Obe, Regina Sent: Thursday, October 04, 2007 9:16 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] Installation Error 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. ________________________________ 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
