How to modify cluster parameters in the PolarDB for PostgreSQL console - PolarDB

This topic describes how to modify cluster parameters in the or PolarDB for PostgreSQL (Oracle Compatible) console.

Note

You can modify only the parameters displayed in the console.

Procedure

Log in to the PolarDB console。
In the upper-left corner, select the region where the cluster is deployed.
Find the target cluster and click its ID.
In the left-side navigation pane, choose Settings and Management > Parameters.
In the upper-left corner of the page, click Modify Parameters.
Find the target parameter and enter a new value.
Note
- You must enter a value that is within the valid range specified in the Range to Be Modified column. Otherwise, an error message appears when you click Submit Changes.
- You can click the icon next to the parameter name to view its description.
In the upper-left corner, click Submit Changes. In the Save Changes dialog box, click OK.

Warning
If the Force Restart value for a parameter is Yes, the cluster will restart when you click OK. Plan your operations accordingly and proceed with caution.

Log in to the PolarDB console。
In the upper-left corner, select the region where the cluster is deployed.
Find the target cluster and click its ID.
In the left-side navigation pane, choose Settings and Management > Parameters.
In the upper-left corner of the page, click Parameter Modification History.
Select a time range and click OK.

The parameter modification records for the selected time range appear. The table includes the following columns: Parameter Name, Old Value, New Value, Effective, and Modification Time.

API	Description
DescribeDBClusterParameters	Queries cluster parameters.
ModifyDBClusterParameters	Modifies cluster parameters.