Description of parameter attributes v15
The description of each group of parameters includes this list of attributes:
- Parameter type. Type of values the parameter can accept. See Setting configuration parameters for a discussion of parameter type values.
- Default value. Default setting if a value isn't explicitly set in the configuration file.
- Range. Allowed range of values.
- Minimum scope of effect. Smallest scope for which a distinct setting can be made. Generally, the minimal scope of a distinct setting is either:
- The entire cluster, meaning the setting is the same for all databases in the cluster and its sessions
per session
, which means the setting might vary by role, database, or individual session. This attribute has the same meaning as theScope of effect
column in the table of Summary of configuration parameters.
- When value changes take effect. Least invasive action required to activate a change to a parameter’s value. All parameter setting changes made in the configuration file can be put into effect by restarting the database server. However, certain parameters require a database server
restart
. Some parameter setting changes can be put into effect with areload
of the configuration file without stopping the database server. Finally, other parameter setting changes can be put into effect with some client-side action whose result isimmediate
. This attribute has the same meaning as theWhen takes effect
column in the table of Summary of configuration parameters. - Required authorization to activate. The type of user authorization to activate a change to a parameter’s setting. If a database server restart or a configuration file reload is required, then the user must be an EDB Postgres Advanced Server service account (
enterprisedb
orpostgres
, depending on the EDB Postgres Advanced Server compatibility installation mode). This attribute has the same meaning as theAuthorized user
column in the table of Summary of configuration parameters.