Re: Closing inactive connections OR user connections limits - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Closing inactive connections OR user connections limits
Date
Msg-id 20021120135451.V30106-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Closing inactive connections OR user connections limits  (Neil Conway <neilc@samurai.com>)
Responses Re: Closing inactive connections OR user connections limits  (Neil Conway <neilc@samurai.com>)
List pgsql-general
On 20 Nov 2002, Neil Conway wrote:

> Francisco Reyes <lists@natserv.com> writes:
> > But wouldn't "vacuum full" still fail?
>
> Not if the connection is made to the database as the PostgreSQL
> superuser.

So this would be new to 7.3. Right?
Right now if there are connections open "vacuum full" will wait from those
connectins to close, even if the vacuum is done from the superuser.

> Heh, no where at the moment, as there wasn't isn't any documentation
> on this new feature :-) Attached is a patch that adds some (also sent
> to -patches).

So there will be a way to reserve connectinos for the super-user, but will
there be a way to limit number of connection per user?


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Closing inactive connections OR user connections limits
Next
From: Medi Montaseri
Date:
Subject: Re: Closing inactive connections OR user connections limits