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 userAdministrator. 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.
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]
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 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
