Wiki / Configuration Parameters

Determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). This parameter can only be set at server start. PostgreSQL sizes certain resources based directly on the value of max_connections. Increasing its value leads to higher allocation of those resources, including shared memory. When running a standby server, you must set this parameter to the same or higher value than on the primary server. Otherwise, queries will not be allowed in the standby server.

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

boot val

100

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

1

name

max_connections

short desc

Sets the maximum number of concurrent connections.

source

pg-settings-source-snapshot

unit

Unknown

vartype

integer