↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

superuser_reserved_connections

Determines the number of connection “slots” that are reserved for connections by PostgreSQL superusers. At most max_connections connections can ever be active simultaneously. Whenever the number of active concurrent connections is at least max_connections minus superuser_reserved_connections, new connections will be accepted only for superusers. The connection slots reserved by this parameter are intended as final reserve for emergency use after the slots reserved by reserved_connections have been exhausted. The default value is three connections. The value must be less than max_connections minus 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.

Reading PG 18·Select a recorded version

boot val
3
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
superuser_reserved_connections
short desc
Sets the number of connection slots reserved for superusers.
source
pg-settings-source-snapshot
unit
Unknown
vartype
integer

Definition PG 18

Determines the number of connection “slots” that are reserved for connections by PostgreSQL superusers. At most max_connections connections can ever be active simultaneously. Whenever the number of active concurrent connections is at least max_connections minus superuser_reserved_connections, new connections will be accepted only for superusers. The connection slots reserved by this parameter are intended as final reserve for emergency use after the slots reserved by reserved_connections have been exhausted. The default value is three connections. The value must be less than max_connections minus reserved_connections. This parameter can only be set at server start.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:54bfaae1db75fd1f5f24d4255f96922aa4263345858d49c4a220f024c3aa6aec

Text language: en · wiki-repair-20261023:54bfaae1db75fd1f5f24d4255f96922aa4263345858d49c4a220f024c3aa6aec