5.7. Configuration Presets #
Configuration presets are sets of Postgres Pro configuration parameters that apply to instances. Once a configuration preset is applied to an instance, the corresponding values are automatically specified for its parameters.
The following system presets exist in PPEM:
Settings for 1C
Settings for OLTP
PPEM provides the following ways of applying configuration presets:
Applying a preset to an individual instance at creation time from the Instances page.
Applying a preset to multiple existing instances from the Configuration presets page.
Applying a preset to multiple existing instances by using a mass instance operation.
Applying or removing a preset to or from the already existing individual instance from the Instances page.
This section explains how to manage configuration presets. It includes the following instructions:
Creating a Configuration Preset
In the navigation panel, go to Settings → Configuration presets.
In the top-right corner of the page, click Create preset.
Enter parameters of the new configuration preset (parameters marked with an asterisk are required):
Name.
Description: The short description of the configuration preset.
The maximum recommended length is 20–30 characters.
Note: The full description of the configuration preset.
Configuration parameters: The configuration parameters that will be added to the preset.
Enter the configuration parameter and its value.
You can add multiple configuration parameters by clicking Add.
You can delete multiple configuration parameters by clicking
next to the parameter value.
Click Create preset.
Viewing Configuration Presets
In the navigation panel, go to Settings → Configuration presets.
The table of configuration presets with the following columns will be displayed:
Name: The name and full description of the configuration preset.
Configuration parameters: The number of configuration parameters in the preset.
You can view the full list of configuration parameters and their short descriptions by clicking
next to the configuration preset name. Title: The short description of the configuration preset.
Actions.
For more information about available actions, refer to other instructions in this section.
Applying a Configuration Preset
Important
When you apply a configuration preset, the instances can be automatically restarted if it is required for changes to take effect.
To apply a configuration preset to one or more instances:
In the navigation panel, go to Settings → Configuration presets.
If the configuration preset increases and decreases the values of the configuration parameters at the same time, split it into two presets: the one that increases values and the other that decreases values.
Then apply both presets individually.
Click
next to the configuration preset. In Instances, select the instances to which the configuration preset will be applied.
The order in which you select the instances is the order in which the configuration preset is applied to them.
Important
If you select a configuration preset that increases the values of the configuration parameters, first apply it to standby/follower nodes. Otherwise, first apply the configuration preset to the primary/leader node.
Applying a configuration preset in the wrong order may cause standby/follower nodes to shut down.
Click Next.
In Confirmation, review the list of instances and configure compatibility check:
Review the list of instances and the order in which the configuration preset is applied to them.
Select whether to verify compatibility between the configuration preset and the instance before applying the preset. If the compatibility check fails, the configuration preset is not applied to the instance.
The compatibility check does not guarantee that no errors will occur when applying the configuration preset.
You can select one of the following values:
For each instance
No check
Click Apply.
Editing a Configuration Preset
Important
System configuration presets cannot be edited.
To edit a configuration preset:
In the navigation panel, go to Settings → Configuration presets.
Click
next to the configuration preset. Edit configuration preset parameters.
Click Apply changes.
Deleting a Configuration Preset
Important
System configuration presets cannot be deleted.
Deleted user configuration presets cannot be restored.
To delete a configuration preset:
In the navigation panel, go to Settings → Configuration presets.
Click
next to the configuration preset. Confirm the operation and click Delete.