This topic describes how to view and reconfigure some parameters for an RDS for 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

  1. Log on to the RDS console.
  2. Select the target region.选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, select Parameters.
  5. On the Modifiable Parameters tab, reconfigure one or more parameters at the same time. The procedure is as follows:
    • Reconfigure a parameter

      1. Click the 修改参数值按钮 icon corresponding to the parameter to be reconfigured.
      2. Enter a new value and click Confirm.
      3. Click Apply Changes.
      4. In the message that appears, click Confirm.
      提交参数变更
    • Reconfigure parameters in batches

      1. Click Export Parameters to download the parameter file.
      2. Open the file and reconfigure parameters.
      3. After the parameters are reconfigured, click Import Parameters.
      4. 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.
      5. Confirm the parameters after reconfiguration in the parameter list, and click Apply Changes.
      提交变更

View the parameter reconfiguration history

  1. Log on to the RDS console.
  2. Select the target region.选择地域
  3. Find the instance and click the instance ID.
  4. In the left-side navigation pane, select Parameters.
  5. Click the Modification History tab.
  6. 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.