Re: [GENERAL] Password authentication failed
Connect to PostgreSql as Postgres user (default database user): psql yourdb -U Postgres then you will be asked for password selected during the installation. Hope this will help. JB - Original Message - From: Suresh Nimbalkar To: pgsql-general@postgresql.org Sent: Tuesday, May 01, 2007 1:29 PM Subject: [GENERAL] Password authentication failed Hi! I am a complete newbee to Postgres. Have installed Postgres on Windows 2003 server SP1 a week back. When I try to log-in to the server (by writting psql mydb at command prompt in postgres/bin directory), I keep getting a message "psal: FATAL: password authentication failed for user"Administrator". I have installed Postgres as an Administrator and log-in to the server as administrator. I don't think I am making mistake in entering the password. It's quite frustrating. Will someone please help? Thanks and regards Vedsur -- Ahhh...imagining that irresistible "new car" smell? Check out new cars at Yahoo! Autos.
[GENERAL] Password authentication failed
Hi! I am a complete newbee to Postgres. Have installed Postgres on Windows 2003 server SP1 a week back. When I try to log-in to the server (by writting psql mydb at command prompt in postgres/bin directory), I keep getting a message "psal: FATAL: password authentication failed for user"Administrator". I have installed Postgres as an Administrator and log-in to the server as administrator. I don't think I am making mistake in entering the password. It's quite frustrating. Will someone please help? Thanks and regards Vedsur - Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.
Re: [GENERAL] Password authentication failed for user
On Tue, Jun 07, 2005 at 11:17:52AM -0400, Robert Fitzpatrick wrote: > > I have a database that is used every day for the past year and all of a > sudden, this morning, I get a report that a user cannot login. I have > doubled checked the pg_hba.conf file, which has not been changed in > several months. But only this one user even after resetting the > password, any other user works fine and if I update the pg_hba.conf file > to trust that user, it works. What can cause this? I don't know if I > should post by pg_hba.conf file here, but like I said, nothing has > changed in several months and this problem just appeared today. Apparently something has changed -- the question is what? If nothing on the server, what about on the user's machine? When was the last time it was known for certain to have worked? What method were you using before you changed it to "trust"? If you change it back, can you log in as the user from someplace that works for other users? Can the user in question log in as any other user from wherever his or her own account is failing? What error shows up in the server's logs? Are you restricting logins by IP address? If so, has the user's IP address changed? It might be useful to see the contents of pg_hba.conf. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Password authentication failed for user
I have a database that is used every day for the past year and all of a sudden, this morning, I get a report that a user cannot login. I have doubled checked the pg_hba.conf file, which has not been changed in several months. But only this one user even after resetting the password, any other user works fine and if I update the pg_hba.conf file to trust that user, it works. What can cause this? I don't know if I should post by pg_hba.conf file here, but like I said, nothing has changed in several months and this problem just appeared today. -- Robert ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] password authentication failed for ..
Doug McNaught <[EMAIL PROTECTED]> writes: > "Manu M P" <[EMAIL PROTECTED]> writes: >> I then created the "passwords" file in $PGDATA using pg_pasword and >> added entries for the two users "test1" and "test2". > I've never heard of a 'pg_password' program and it is not part of the > standard distribution. pg_passwd did exist in releases up to 7.2, but we got rid of it because that functionality got moved into ALTER USER. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] password authentication failed for ..
"Manu M P" <[EMAIL PROTECTED]> writes: > Hi > > I have the data base "test" and two users "test1" "test2". I added the following > record to pg_hba.conf > > local test password passwords > > I then created the "passwords" file in $PGDATA using pg_pasword and > added entries for the two users "test1" and "test2". Ummm... Passwords are stored in the 'pg_shadow' table and set using CREATE/ALTER USER, not in a file. I've never heard of a 'pg_password' program and it is not part of the standard distribution. -Doug ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] password authentication
Phuong Ma wrote: >Hi, > > I was wondering what the different methods of creating a password >accomplish because I created a password for a test user using the >command WITH PASSWORD. I tried testing to see if I could log on without >a password, and it worked. Is there anything else I would need to do to >activate the password authentication? Does the pg_hba.conf file have >anything to do with this? If it does, and I only want to create a >password for this one user, would I specify it in the pg_hba.conf file? Use pg_hba.conf to turn on password checking. Checking is done if the connection method, database (and connection source for TCP/IP) match a line in pg_hba.conf that requires it. You cannot turn on checking per _user_. It's all users or none. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "For this reason I also suffer these things, but I am not ashamed; for I know whom I have believed, and am persuaded that He is able to keep that which I have committed unto him until that day." II Timothy 1:12 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
