Home / server / Questions / 185498
Accepted
Woot4Moo
Asked: 2010-09-29 09:45:19 +0800 CST

Postgres database post-expiration of user password unable to login

  • 772

I have a test environment where there exist 2 roles:

group role with Superuser permissions (no login) and
user role that belongs to group.

When I trip the password to expire on this account I am unable to login again and therefore unable to change my password. How is the user to change their password once the valid until expires?

password postgresql

1 Answers

  1. Best Answer

    Another superuser has to change the password for this user. After succesfull login, the user can change his own password again.

    • 1