Re: Temporarily suspend a user account?

On 2/6/15, David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <
> ml-node+s1045698n5836989h83(at)n5(dot)nabble(dot)com> wrote:
>
>> Might not do what you want, but I just change the password.
>>
>>
> ​How do you do that and re-enable using the previous password?
>
> David J.

Encrypted passwords are kept in the pg_shadow file and should start with 'md5'.

Just save a copy of the encrypted password for that user and when you
want to re-enable that user do:

alter user xxx encrypted password 'md5xxxxxxxx';

I have tested this on 9.3.5.
--
Mike Nolan