Postgres Pro
Downloads
Home   >   mailing lists

Re: REVOKE command not working as expected - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: REVOKE command not working as expected
Date
Msg-id CAOR=d=0P5Ztk=30+otLZeqQo=HrpQ6oHjh5OtbiPa5LfDfBaXw@mail.gmail.com
Whole thread Raw
In response to REVOKE command not working as expected  (Guillermo Carrasco <guillermo.carrasco@scilifelab.se>)
Responses Re: REVOKE command not working as expected  (Guillermo Carrasco <guillermo.carrasco@scilifelab.se>)
Re: REVOKE command not working as expected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
On Tue, Nov 12, 2013 at 7:58 AM, Guillermo Carrasco
<guillermo.carrasco@scilifelab.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.

pgsql-admin by date:

Previous
From: Guillermo Carrasco
Date:
Subject: REVOKE command not working as expected
Next
From: Guillermo Carrasco
Date:
Subject: Re: REVOKE command not working as expected