This topic describes how to manage the parameters of an ApsaraDB RDS for PostgreSQL instance by using the ApsaraDB RDS console or the ApsaraDB RDS API. You can view the values of these parameters, reconfigure these parameters, and view the parameter reconfiguration history.

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. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.Select a region
  2. Find your RDS instance and click its ID. 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. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.Select a region
  2. Find your RDS instance and click its ID. In the left-side navigation pane, click Parameters.
  3. Click the Edit History tab.
  4. Select a time range and click OK.

Related operations

API Description
Modify parameters of an ApsaraDB for RDS instance Reconfigures the parameters of an ApsaraDB RDS instance.
Query the parameter template of an ApsaraDB for RDS instance Queries the parameter templates that are available to an ApsaraDB RDS instance.
Query parameter configurations Queries the parameter settings of an ApsaraDB RDS instance.

Parameters

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