Revisions to PostgreSQL user can not connect to server after changing password

edited tags

Link

edited Mar 9, 2017 at 20:06

Evan Carroll

65.8k
50
261
512

Tweeted twitter.com/#!/StackDBAs/status/627807436125118464

occurred Aug 2, 2015 at 11:45

remove thanks

Source Link

edit approved Mar 7, 2013 at 15:34

Stephane Rolland

9k
11
34
41

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? Thanks.

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

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? Thanks.

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

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