ApsaraDB RDS:Use parameter templates

Create a parameter template manually

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. Click Create Parameter Template.

3. Configure the following parameters.

   Parameter	Description
   Template Name	The name of the template. The name must be 8 to 64 characters in length, start with a letter, and can contain only letters, digits, periods (.), and underscores (_). Chinese characters are not allowed.
   Database Engine	Select PostgreSQL.
   Engine Version	Select a database version.
   Description	Enter a description for the template, which can be up to 200 characters in length.
   Add Parameter	Click Add Parameter to add a row where you can select a Parameter Name and set its value. You can also view information such as the valid value range and the default value. Note For a list of available parameters, see the Editable Parameters tab on the Parameters page of your instance. To configure another parameter, click Add Parameter again. To remove a parameter, click Delete on the right side of the parameter.
   Import	After you modify an exported template, you can click Import and paste the parameters to create a template. For more information about how to export a template, see Modify the parameters of an ApsaraDB RDS for PostgreSQL instance.

4. Click Confirm.

Apply a parameter template during instance creation

Apply a parameter template to multiple instances

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. On the Custom Parameter Templates or System Parameter Templates tab, find the template that you want to apply and click Apply to Instance in the Actions column.

   Note

   If you apply multiple templates to an instance in sequence, the last applied template overrides the parameters of the previous ones.

3. From the instance list on the left, select the target instances. Click to move the instances to the right. Review the Parameter Comparison section to verify the changes.

4. Click OK.

Apply a parameter template to a single instance

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the left-side navigation pane, click Parameters.

3. On the Editable Parameters tab, click Apply Template.

4. Select the Template Name of a template that you want to apply.

   Note

   You can log on to the ApsaraDB RDS console, click Parameter Templates in the left-side navigation pane, and then select a region to view the created templates.

5. Click OK to apply the template.

Clone a custom parameter template

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. In the list of custom parameter templates, find the template that you want to clone. In the Actions column, click and select Clone.

3. Configure the following parameters.

   Parameter	Description
   Region	The destination region to which you want to clone the template.
   Template Name	The name of the template. The name must be 8 to 64 characters in length, start with a letter, and can contain only letters, digits, periods (.), and underscores (_). Chinese characters are not allowed.
   Description	Enter a description for the template, which can be up to 200 characters in length.

4. Click OK.

View a parameter template

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. On the Custom Parameter Templates or System Parameter Templates tab, click the ID of the target parameter template to view its parameter settings.

Modify a parameter template

You can modify a custom parameter template that you created.

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. Find the target custom parameter template. In the Actions column, click and select Modify.

3. After you complete the modifications, click OK.

Delete a parameter template

You can delete a custom parameter template that you created.

1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Parameter Templates. In the top navigation bar, select a region.

2. Find the target custom parameter template. In the Actions column, click and select Delete.

3. In the confirmation dialog box that appears, click OK.

   Note

   You cannot delete a custom parameter template if it is applied to one or more instances.

   For example, if custom_template_1 is applied to instance_A and instance_B, you cannot delete custom_template_1. To delete the template, you must first apply a different template to instance_A and instance_B.