On 2/6/15, David G Johnston <[email protected]> wrote: > On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] < > [email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
