On 2/6/15, David G Johnston <david.g.johnston@xxxxxxxxx> wrote: > On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] < > ml-node+s1045698n5836989h83@xxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
