Changing postgres password for enduser

Question

is it possible to change an encrypted password with a sql query?

I have a user who for some reason can't log in and can't make her reset password recredentialing work.

Laurenz Albe · Accepted Answer · 2018-05-14 21:27:36Z

2

This is simple: just use ALTER ROLE with the encrypted password.

ALTER ROLE luser PASSWORD 'md565b6fad0e85688f3f101065bc39552df';

Be aware that the password might end up in the log file if logging is configured appropriately.

answered May 14, 2018 at 21:27

Laurenz Albe

257k22 gold badges310 silver badges387 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1