Through the TencentDB for PostgreSQL console, you can create custom parameter templates to configure parameters in batches according to your business scenarios.
You can use the database parameter template to manage the configuration of database engine parameters. A parameter group acts like a container for engine configuration values, which can be applied to one or more database instances.
Parameter templates support the following features. Users can log in to the PostgreSQL console, select the Parameter Template page from the left navigation to view parameters:
Support the creation of new templates to generate custom parameter optimization schemes.
Support importing templates from PostgreSQL configuration files **.conf.
Save parameter configurations as templates.
Import parameters from templates to apply to one or more instances.
Support comparing between two parameter templates.
Notes
Database instances that use a parameter template will not automatically update with the template; manual bulk instance updates are required.
You can apply the parameter changes to single or multiple instances by importing a template.
Creating a Parameter Template
To use your own database parameter template, you can create a new template, modify the necessary parameters and apply it to your instances.
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation, and click Create Template.
2. In the dialog box that appears, configure the following, and click Create and Set Parameters.
Template Name: Enter a unique template name.
Engine: Select the appropriate database engine, such as PostgreSQL or SQL Server compatible.
Database Version: Select a database version.
Template Description: Enter a brief description of the parameter template.
3. After creation, you can modify, import, and export parameters on the template details page.
Applying a Parameter Template to Instances
Note:
Before applying a parameter template to multiple instances, make sure that the instances do support those parameters.
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation.
2. In the Parameter Template list, find the template you need to apply, click Apply to Instance.
3. On the pop-up page, select the execution mode and instances, ensure all parameter modifications are correct, then click Submit.
PostgreSQL Instance: Select the instances that need to apply the parameter template in the specified region.
Parameter Comparison: View the changed parameter values of the selected instance.
Copying a Parameter Template
To include most of the custom parameters and values of an existing parameter template in a new template, you can copy the existing template.
Option 1. Copying an existing parameter template
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation, click on the Template ID or the Operation column's View Details to enter the template details page.
2. On the template details page, click Save as Template.
3. In the pop-up dialog box, specify the following configurations:
Template Name: Enter a unique template name.
Template Description: Enter a brief description of the parameter template.
4. After confirming that everything is correct, click OK to save the current parameter template as a new one, completing the copying operation.
Option 2. Saving parameters of an instance as a parameter template
1. Sign in to the PostgreSQL console, select Instance List on the left navigation, click an instance ID to enter the management page.
2. Select the Parameter Settings tab, click Save as Template.
3. In the pop-up dialog box, specify the following configurations:
Template Name: Enter a unique template name.
Template Description: Enter a brief description of the parameter template.
4. After confirming that everything is correct, click OK to save the current parameter template as a new one, completing the copying operation.
Modifying Parameter Values in a Parameter Template
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation, and click on the Template ID to enter the template details page.
2. On the template details page, click Modify Parameters in Batches, or in the running value column, click the "Modify Parameter Value" icon.
Importing a Parameter Template
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation, and click on the Template ID to enter the template details page.
2. On the template details page, click Import Parameters.
Note:
When choosing to import parameters, on the local file import page, when selecting a parameter configuration file, it is important to ensure that the format of the configuration file matches the configuration file format of the PostgreSQL database server, or use the file template of exported parameters, otherwise, an import failure message will appear.
3. In the pop-up window, select a file and click Import and Overwrite Original Parameters.
Exporting a Parameter Template
Method 1
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation.
2. In the parameter template list, in the Operation column of the desired template, click Export.
Method 2
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation, and click on the Template ID to enter the template details page.
2. At the top of the template details page, click Export Parameters.
Deletes parameter template
If a parameter template is created redundantly or no longer needed, it can be easily deleted.
1. Sign in to the PostgreSQL console, select Parameter Template on the left navigation.
2. In the parameter template list, in the Operation column of the desired template, click Delete.
Yes
No
Was this page helpful?