Manage the parameters of an ApsaraDB RDS for PostgreSQL instance

Reconfigure parameters

Precautions

• The reconfiguration of some parameters triggers a restart of your RDS instance. After you reconfigure these parameters and click Apply Changes, your RDS instance immediately restarts. To check whether the reconfiguration of a parameter triggers a restart, you need to log on to the ApsaraDB RDS console, go to the Editable Parameters tab, and then view the value in the Force Restart column for the parameter. If the value is Yes, the reconfiguration of the parameter triggers a restart. If the value is No, the reconfiguration of the parameter does not trigger a restart. The restart causes a disconnection of your application from your RDS instance. Proceed with caution. Before the restart is triggered, we recommend that you plan suitable service arrangements.
• The new values of the reconfigured parameters must be within the value ranges that are provided in the Value Range column on the Editable Parameters tab in the ApsaraDB RDS console.

Procedure

1. Visit the RDS instance list, select a region above, and click the target instance ID.
2. In the left-side navigation pane, click Parameters.
3. On the Editable Parameters tab, reconfigure the parameters of your RDS instance based on your business requirements.
   • If you want to reconfigure a single parameter, perform the following steps:
     1. Find the parameter and in the Running Parameter Value column click the icon.
     2. Enter a new value and click OK.
     3. Click Apply Changes.
     4. In the message that appears, click OK.
     
   • If you want to reconfigure multiple parameters at a time, perform the following steps:
     1. Click Export Parameters to download the parameter settings of your RDS instance as a file to your computer.
     2. Open the file and reconfigure the parameters.
     3. Click Import Parameters.
     4. In the Import Parameters dialog box, paste the parameters and their new values that you have copied from the file. Then, click OK.
     5. Confirm the values of the reconfigured parameters and click Apply Changes.

View the parameter reconfiguration history

1. Visit the RDS instance list, select a region above, and click the target instance ID.
2. In the left-side navigation pane, click Parameters.
3. Click the Edit History tab.
4. Select a time range and click OK.

Related operations

Parameters

For more information about the parameters that are supported for PostgreSQL, see the official PostgreSQL documentation.