Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillermo Carrasco
Subject Re: REVOKE command not working as expected
Date
Msg-id CAH-nkqk6amrDozECFKo+kakXPocGm512W=-7x013wxf0H-veoQ@mail.gmail.com
Whole thread Raw
In response to Re: REVOKE command not working as expected  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: REVOKE command not working as expected  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
Hi,

Thanks for your answer, I know, that's why we have this statement: https://github.com/guillermo-carrasco/scilifelab/blob/master/scripts/dbsync.sh#L20


On Tue, Nov 12, 2013 at 4:01 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
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.



--
------------------------------------------------------------------------
Guillermo Carrasco Hernández, Computer Scientist

------------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: REVOKE command not working as expected
Next
From: Tom Lane
Date:
Subject: Re: REVOKE command not working as expected