Re: Temporarily suspend a user account?

From: Felipe Gasper <felipe(at)felipegasper(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporarily suspend a user account?
Date: 2015-02-06 22:55:03
Message-ID: 54D54647.5070008@felipegasper.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6 Feb 2015 4:51 PM, David G Johnston wrote:
> On Fri, Feb 6, 2015 at 3:41 PM, Felipe Gasper [via PostgreSQL] <[hidden
> email] </user/SendEmail.jtp?type=node&node=5837007&i=0>>wrote:
>
>
> So, this works when I do it manually, but not when I script it.
>
> Is it possible that this change doesn’t take effect immediately? Is
> there any way to tell when it does (besides just waiting until login
> attempts fail)?
>
>
> ​It should take effect when you commit the transaction in which you
> perform the update...
>
> The active sessions would remain logged in but future attempts to login
> would fail.
>

Yeah now I’m wondering if DBD::Pg is doing some weird caching.

Anyhow, I’ll figure it out. Thank you! :)

-FG

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2015-02-06 23:01:11 Re: Temporarily suspend a user account?
Previous Message David G Johnston 2015-02-06 22:51:27 Re: Temporarily suspend a user account?