5.21. Instance Parameters #
PPEM allows viewing and editing parameters of the DBMS instance.
The ALTER SYSTEM command is used to modify instance parameters. It modifies the postgresql.auto.conf file.
If an instance parameter was initially specified in the main configuration file, such as postgresql.conf, but later changed via PPEM and written to postgresql.auto.conf, the web application will display this parameter in both files. This is normal because values from postgresql.auto.conf take precedence over other configuration files.
PPEM uses the pg_reload_conf() function to apply instance parameters without restarting the instance.
Viewing Instance Parameters
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Parameters.
The instance parameters will be displayed, grouped into tables by different semantic categories. The tables include the following columns:
Parameter: The name and description of the instance parameter. If the instance parameter is specified in a configuration file, the path to this file and the row number will be displayed next to it.
This column also displays the instance parameter application status and errors, if they occurred.
To open a full description of the instance parameter in the official Postgres Pro documentation, click its name.
Value.
Default value.
Source: The source of the instance parameter value.
Possible values:
default: This is the default instance parameter value.
configuration file: The instance parameter value is specified in the configuration file.
override: The instance parameter value is overridden at the instance initialization stage.
Editing Instance Parameters
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Parameters.
In Value, perform one of the following actions:
Enable or disable the instance parameter by turning on or off the corresponding toggle.
Change the instance parameter value by specifying the new value in the corresponding field.
When an instance parameter is edited, an icon for restoring the previous value
is displayed next to it. (Optional) To reset all edited but not yet saved instance parameters, in the bottom-right corner of the page, click Reset.
In the bottom-right corner of the page, click Save.
The action selection window will open if instance parameters, which require an instance restart, were edited.
Select one of the following actions:
Apply changes and restart the instance: The instance parameter changes will be applied, the instance will restart automatically.
Apply changes, but restart instance later manually: The instance parameter changes will be applied, but you will need to restart the instance manually.
Click Apply.
Confirm the operation.
Important
Restarting the DBMS instance terminates all its active sessions. The restart process may take a significant time due to the checkpoint execution. The restart duration depends on the configuration and the instance load.
It is recommended to pay special attention to restarts, especially in production environments with strict DBMS downtime requirements.