This topic describes how to view and reconfigure some parameters for an RDS PostgreSQL instance through the RDS console or APIs and how to view the parameter reconfiguration history through the RDS console.
View and reconfigure parameters
Precautions
- When you reconfigure parameters on the Modifiable parameters tab, see the Value Range column corresponding to each parameter.
- After you reconfigure certain parameters, you must restart the instance for the changes to take effect. For more information, see the Force Restart column on the Modifiable parameters tab. A restart disconnects the instance. We recommend that you make appropriate service arrangements before you restart an instance. Proceed with caution.
Procedure
- Log on to the RDS console.
- Select the target region.
- Find the target RDS instance and click the instance ID.
- In the left-side navigation pane, select Parameters.
- On the Modifiable Parameters tab, reconfigure one or more parameters at the same time. The procedure is as follows:
-
Reconfigure a parameter
- Click the
icon corresponding to the parameter to be reconfigured.
- Enter a new value and click Confirm.
- Click Apply Changes.
- In the message that appears, click Confirm.
- Click the
-
Reconfigure parameters in batches
- Click Export Parameters to download the parameter file.
- Open the file and reconfigure parameters.
- After the parameters are reconfigured, click Import Parameters.
- In the Import Parameters dialog box that appears, copy the parameters and their new values in the file and paste in the editing field and click OK.
- Confirm the parameters after reconfiguration in the parameter list, and click Apply Changes.
-
View the parameter reconfiguration history
- Log on to the RDS console.
- Select the target region.
- Find the instance and click the instance ID.
- In the left-side navigation pane, select Parameters.
- Click the Modification History tab.
- Select a time range and click Search.
APIs
Operation | Description |
---|---|
DescribeParameterTemplates | Queries database parameter templates. |
DescribeParameters | Queries the current parameter configurations of an instance. |
ModifyParameter | Reconfigures the parameters of an instance. |
Parameter description
For more information about parameter settings, see PostgreSQL Official Documentation.