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

Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Tue, Nov 12, 2013 at 7:58 AM, Guillermo Carrasco
> <guillermo.carrasco@scilifelab.se> wrote:
>> 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.

My money is on autovacuum.

            regards, tom lane