Re: REVOKE command not working as expected

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Guillermo Carrasco <guillermo(dot)carrasco(at)scilifelab(dot)se>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: REVOKE command not working as expected
Date: 2013-11-12 15:01:17
Message-ID: CAOR=d=0P5Ztk=30+otLZeqQo=HrpQ6oHjh5OtbiPa5LfDfBaXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Nov 12, 2013 at 7:58 AM, Guillermo Carrasco
<guillermo(dot)carrasco(at)scilifelab(dot)se> wrote:
> Hi everyone,
>
> The problem is that sometimes (apparently random), even after having invoked
> EVOKE CONNECT ON DATABASE \"$DB\" FROM PUBLIC;, when the scripts starts
> dumping, it fails because it says that there are some active connections.

Revoking connection does not disconnect currently connected clients.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillermo Carrasco 2013-11-12 15:02:37 Re: REVOKE command not working as expected
Previous Message Guillermo Carrasco 2013-11-12 14:58:12 REVOKE command not working as expected