Wiki / Configuration Parameters

Determines the number of connection “slots” that are reserved for connections by roles with privileges of the pg_use_reserved_connections role. Whenever the number of free connection slots is greater than superuser_reserved_connections but less than or equal to the sum of superuser_reserved_connections and reserved_connections, new connections will be accepted only for superusers and roles with privileges of pg_use_reserved_connections. If superuser_reserved_connections or fewer connection slots are available, new connections will be accepted only for superusers. The default value is zero connections. The value must be less than max_connections minus superuser_reserved_connections. This parameter can only be set at server start.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

0

category

Connections and Authentication / Connection Settings

context

postmaster

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

262143

metadata version

18

min val

0

name

reserved_connections

short desc

Sets the number of connection slots reserved for roles with privileges of pg_use_reserved_connections.

source

pg-settings-source-snapshot

unit

Unknown

vartype

integer