This topic explains how to modify cluster parameters in the PolarDB for PostgreSQL (Oracle compatible) console.
Only the parameters displayed in the console can be modified.
Procedure
-
Log on to the PolarDB console. In the left-side navigation pane, click Clusters. Select the region where your cluster is located, and then click the cluster ID.
-
In the left-side navigation pane, choose .
-
In the upper-left corner of the page, click Modify Parameters.
-
Find the target parameter and enter a new value.
Note-
Enter a value that is within the Range to Be Modified specified for the parameter. Otherwise, an error message appears when you click Submit Changes.
-
You can click the
icon next to a parameter name to view its detailed description.
-
-
In the upper-left corner, click Submit Changes. In the Save Changes dialog box that appears, click OK.
WarningFor parameters with Yes in the Force Restart column, the cluster restarts after you click OK. This action can interrupt your services, so plan accordingly and proceed with caution.
View parameter modification history
-
Log on to the PolarDB console. In the left-side navigation pane, click Clusters. Select the region where your cluster is located, and then click the cluster ID.
-
In the left-side navigation pane, choose .
-
In the upper-left corner of the page, click Parameter Modification History.
-
Select a time range and click OK.
The results table includes the Parameter Name, Old Value, New Value, Is Effective, and Modification Time columns.
Related APIs
|
API |
Description |
|
Queries the parameters of a specified cluster. |
|
|
Modifies one or more parameters of a specified cluster. |