<p>This article describes how to import a parameter.</p> <p><span style="font-size:18px"><strong>Overview</strong></span></p> <p>If you want to modify the values of parameters in bulk, you can modify them by importing parameters.</p> <p>A general instance, disaster recovery instance, and read-only instance support modifying parameters in bulk.</p> <p>Some parameters will be valid only after you reboot the instance. For more information about these parameters, see prompt messages in the console.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <p>You have successfully created an instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Instance_Management.Create_Instance.Create_Common_Instance" target="_blank">Create a General Instance</a>, <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Instance_Management.Create_Instance.Create_Slave_Instance" target="_blank">Create a Remote Disaster Recovery Instance</a> or <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Instance_Management.Create_Instance.Create_Read_Only_Instance" target="_blank">Create a Read-only Instance</a>.</p> <p><span style="font-size:18px"><strong>Usage Guidelines</strong></span></p> <ol> <li>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.</li> <li>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.</li> <li>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.</li> <li>In the process of rebooting an instance, the system will be interrupted in seconds. We recommend that you modify parameters in the <strong>time segment</strong> you set.</li> </ol> <p><span style="font-size:18px"><strong>Procedures</strong></span></p> <p>1.&nbsp; Log in to the <a href="http://pinganyun.com/console/rds/overview" target="_blank">RDS Console</a>.</p> <p>2.&nbsp; In the left navigation pane, click <strong>RDS-PostgreSQL</strong> to enter the <strong>DBPaaS for RDS-PostgreSQL</strong> page.</p> <p>3.&nbsp; Select the target region.</p> <p>4.&nbsp; In the <strong>Operation</strong> column of the target instance, click <strong>Manage</strong>. Click <strong>Parameters</strong> tab.</p> <p>5.&nbsp; Select <strong>Parameter List</strong>, and click <strong>Import Parameters</strong> at the bottom of the page to enter the <strong>Import Parameters</strong> page.</p> <p>6.&nbsp; Enter the parameter and its value to be modified, such as a=20, 100; b=200.</p> <p>&nbsp; &nbsp; <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707103005-11641d3b9899.png" style="height:23px; margin:0px; width:90px" />:</p> <p>&nbsp; &nbsp; &bull;&nbsp; Enter with format of parameter name = parameter value.</p> <p>&nbsp; &nbsp; &bull;&nbsp; Use comma (,) to separate multiple values of one parameter.</p> <p>&nbsp; &nbsp; &bull;&nbsp; Use semicolon (;) to separate multiple parameters.</p> <p>7.&nbsp; Click <strong>Save</strong>.</p> <p>8.&nbsp; Click <strong>Submit</strong> at the bottom of the page. Click <strong>Save</strong> on the page of <strong>Hints</strong>.</p> <p>&nbsp; &nbsp;&nbsp;<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707103005-11641d3b9899.png" style="height:23px; margin:0px; width:90px" />: If you do not want to submit the modified parameter, you can click <strong>Cancel</strong> at the bottom of the page to keep the original value unchanged.</p> <p><span style="font-size:18px"><strong>Result</strong></span></p> <p>&bull;&nbsp; You will see an <strong>Operation succeeded</strong> message at the bottom of the page.</p> <p>&bull;&nbsp; On the page of <strong>Parameter List</strong>, the <strong>Running Parameters</strong> of the target parameter is the value after modification.</p> <p>&nbsp; &nbsp;&nbsp;<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707103005-11641d3b9899.png" style="height:23px; margin:0px; width:90px" />: <strong>Edit Parameter</strong> in the <strong>Operation</strong> column of the target parameter will be grayed out after modification and can be edited after you refresh the page.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707103015-174a751196b7.png" style="height:148px; width:830px" /></p>