Reconfigure parameters for an RDS PostgreSQL instance

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

Parameter description

For more information about parameter settings, see PostgreSQL Official Documentation.