Might not do what you want, but I just change the password. -- Mike Nolan On Fri, Feb 6, 2015 at 4:11 PM, Melvin Davidson <melvin6...@gmail.com> wrote:
> Possibly, > > To disble: > ALTER USER name RENAME TO xname; > > To enable > ALTER USER xname RENAME TO name; > > ??? > > > On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gasper <fel...@felipegasper.com> > wrote: > >> Hello, >> >> Is there a way to temporarily suspend a user account? >> >> I would prefer not to revoke login privileges since that will >> break things that mine pg_users and pg_shadow. >> >> I also am trying to find something that is completely reversible, >> so something like setting connection limit to 0, which would lose a >> potentially customized connection limit, doesn’t work. >> >> We do this in MySQL by reversing the password hash then running >> FLUSH PRIVILEGES; however, that doesn’t seem to work in >> PostgreSQL/pg_authid as some sort of cache prevents this from taking effect. >> >> Has anyone else solved this issue? Thank you! >> >> -Felipe Gasper >> Houston, TX >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >
