up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
67% accept rate
feedback

1 Answer

up vote 0 down vote accepted

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

link|improve this answer
What about in an environment where there is only 1 super user. – Woot4Moo Sep 29 '10 at 13:31
You have to change pg_hba.conf file to allow connections without password, restart the server (to reload the config file), connect without a password (no need anymore) and change your password. After this you have to edit pg_hba.conf again and reload the file again. – Frank Heikens Sep 29 '10 at 14:00
thank you very much Frank, if I had enough rep I would upvote your answer – Woot4Moo Sep 29 '10 at 15:13
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.