PostgreSQL user can not connect to server after changing password

10 votes

6 answers

57536 views

                          I've met this with 4 roles I created:  
After changing password for a user in pgAdmin III using the GUI (1), that user can not log in any more.  
pgAdmin III show error message:

    An error has occurred:
    
    Error connecting to the server: FATAL:  password authentication failed for user "sam"
    FATAL:  password authentication failed for user "sam"

My system: Postgresql 9.2 on Ubuntu 12.04  

Is there any way to fix this?

(1): login with account postgres, right click user in Login Roles, go to tab 'Definition' and enter password

Asked by Cao Minh Tu (613 rep)

Mar 7, 2013, 04:42 AM
Last activity: Oct 20, 2020, 07:33 PM

PostgreSQL user can not connect to server after changing password

Related Questions