TODO Done. Superuser backend slot reservations

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-patches(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: TODO Done. Superuser backend slot reservations
Date: 2002-08-25 22:56:31
Message-ID: Pine.LNX.4.21.0208252339300.16637-200000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

TODO item:

Administration -
Reserve last few process slots for super-user if max_connections
reached

Notes:

Added GUC superuser_reserved_connections such that non-superuser connections
are only acceptable in the first
(max_connections - superuser_reserved_connections) backend slots.

Superuser connections within these first n slots count towards this
non-superuser connection limit. Therefore there can be at most this number
of non-superuser connections but may be less.

In addition, this limit is only checked on initialisation of a backend
process. So reserved slots can be taken by connections that subsequently
lose superuser priviledges thus evading the lower limit on backends.

Passed regression tests, not that it was likely not to.
Behaved as expected in a manual test.

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

Attachment Content-Type Size
sureserve.patch text/plain 5.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2002-08-25 23:26:06 Re: [HACKERS] TODO Done. Superuser backend slot reservations
Previous Message Bruce Momjian 2002-08-25 22:41:07 Re: Fwd: Joins and links

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2002-08-25 23:26:06 Re: [HACKERS] TODO Done. Superuser backend slot reservations
Previous Message Bruce Momjian 2002-08-25 20:40:18 Re: make interfaces/perl5 build properly outside source directory