Forgot to mention - alternatively you could say create an account in PostgreSQL called say Administrator or something that maps to an NT account and then change the line to host all Administrator 127.0.0.1/32 trust for commandline use - PostgreSQL will try to use whatever the logged in user name is if no user is specified or you could still just type in Administrator when asked for a user - so its still a bit lame, but better. PostgreSQL 8.3 will support native windows Integrated security (MS dialect of Kerberos) - so I'm really looking forward to that feature. http://people.planetpostgresql.org/mha/index.php?/archives/155-Integrate d-Security-in-PostgreSQL-8.3.html since it will make management of PostgreSQL accounts integration with windows domain accounts close to par with what I can do with SQL Server management integration with windows domain. Hope that helps, 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
