This article describes how to import a parameter.

Overview

If you want to modify the values of parameters in bulk, you can modify them by importing parameters.

A general instance, disaster recovery instance, and read-only instance support modifying parameters in bulk.

Some parameters will be valid only after you reboot the instance. For more information about these parameters, see prompt messages in the console.

Prerequisites

You have successfully created an instance. For more information, see Create a General Instance, Create a Remote Disaster Recovery Instance or Create a Read-only Instance.

Usage Guidelines

1. When you modify parameters of a general instance in bulk, the same parameters of the citywide and remote disaster recovery instance will be modified at the same time. In addition, the value of the parameters of the citywide and remote disaster recovery instance are identical with those of the general instance.
2. Parameters of a read-only instance can be modified independently from parameters of a general instance. You can modify the parameter value of a citywide or remote read-only instance respectively in the RDS console. The parameter value of a citywide instance can be different from that of a remote read-only instance or a general instance.
3. After you modify parameters of the instance that needs to be rebooted, the system will automatically reboot the general instance, citywide read-only instance, or remote read-only instance.
4. In the process of rebooting an instance, the system will be interrupted in seconds. We recommend that you modify parameters in the time segment you set.

Procedures

1.  Log in to the RDS Console.

2.  In the left navigation pane, click RDS-PostgreSQL to enter the DBPaaS for RDS-PostgreSQL page.

3.  Select the target region.

4.  In the Operation column of the target instance, click Manage. Click Parameters tab.

5.  Select Parameter List, and click Import Parameters at the bottom of the page to enter the Import Parameters page.

6.  Enter the parameter and its value to be modified, such as a=20, 100; b=200.

    :

    •  Enter with format of parameter name = parameter value.

    •  Use comma (,) to separate multiple values of one parameter.

    •  Use semicolon (;) to separate multiple parameters.

7.  Click Save.

8.  Click Submit at the bottom of the page. Click Save on the page of Hints.

    : If you do not want to submit the modified parameter, you can click Cancel at the bottom of the page to keep the original value unchanged.

Result

•  You will see an Operation succeeded message at the bottom of the page.

•  On the page of Parameter List, the Running Parameters of the target parameter is the value after modification.

    : Edit Parameter in the Operation column of the target parameter will be grayed out after modification and can be edited after you refresh the page.