<p>This article describes how to modify some parameters of RDS PostgreSQL in the RDS console.</p> <p><span style="font-size:18px"><strong>Overview</strong></span></p> <p>You can modify advanced parameters that are relevant to PostgreSQL engine in the RDS console to optimize performance.</p> <p>A general instance and disaster recovery instance and read-only instance support modifying parameters.</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 Create a General Instance, Create a Remote Disaster Recovery Instance or Create a Read-only Instance.</p> <p><span style="font-size:18px"><strong>Usage Guidelines</strong></span></p> <ol> <li>When you modify a parameter of a general instance, the same parameter of the citywide and remote disaster recovery instance will be modified at the same time. In addition, the parameter value of the citywide and remote disaster recovery instance is identical with that 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 RDS Console.</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>Edit Parameter</strong> in the operation column of the target parameter to enter <strong>Edit Parameter</strong> page.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707100316-1a216b149aa6.png" style="height:247px; width:522px" /></p> <p>6.&nbsp; Set <strong>Parameter Value</strong>, and click <strong>Save</strong>.</p> <p>7.&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/20200707100345-1919fcc59030.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><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707100324-17bf3bb6902f.png" style="height:467px; width:830px" /></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 <strong>Parameter List</strong> page, 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/20200707100345-1919fcc59030.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/20200707100331-1e6a0a9c9686.png" style="height:146px; width:830px" /></p>