Re: Temporarily suspend a user account? - Mailing list pgsql-general

From David G Johnston
Subject Re: Temporarily suspend a user account?
Date
Msg-id CAKFQuwY2o5xve6+XOd99XkMxKp7q-+wcLV_=7FBHVsg1+wdRiQ@mail.gmail.com
Whole thread Raw
In response to Re: Temporarily suspend a user account?  (Felipe Gasper <felipe@felipegasper.com>)
List pgsql-general
On Fri, Feb 6, 2015 at 3:55 PM, Felipe Gasper [via PostgreSQL] <[hidden email]> wrote:
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! :)

Connection pool sessions are likely remaining connected to the database longer than your application.
​..​

Dave
 


View this message in context: Re: Temporarily suspend a user account?
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Felipe Gasper
Date:
Subject: Re: Temporarily suspend a user account?
Next
From: Jerry Sievers
Date:
Subject: Re: Temporarily suspend a user account?