Re: Closing inactive connections OR user connections limits

Francisco Reyes <lists(at)natserv(dot)com> writes:
> On 20 Nov 2002, Neil Conway wrote:
> > Not if the connection is made to the database as the PostgreSQL
> > superuser.
>
> So this would be new to 7.3. Right?

Yes.

> 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.

Erm, no -- VACUUM FULL doesn't block on connections, it blocks waiting
to acquire locks. Whether or not a client is allowed to connect to the
database has no relation to the locks the client can acquire once
they've connected.

> > 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?

Not in 7.3, AFAIK.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC