• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for PostgreSQL
  5. Modifying Parameters in a Parameter Group

Modifying Parameters in a Parameter Group

You can modify parameters in custom parameter groups.

NOTE:

RDS includes default parameter groups that cannot be modified. You can view them by clicking their names. If a custom parameter group is set incorrectly and causes a database reboot to fail, you can use a default parameter group to reset the database.

Modifying Parameters in a Parameter Group

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Parameter Group Management page, click the target parameter group.
  5. Modify the parameters as required.

    Relevant parameters are as follows:

    • For details on parameter descriptions, visit the PostgreSQL official website.
    • If log_statement is set to ddl, mod, or all, the operations for creating and deleting database users (including passwords and other sensitive information) are recorded. This operation affects database performance. Exercise caution when setting this parameter.
    • search_path must be set to a schema sequence where schemas are separated by commas (,). Ensure that the schemas exist. Otherwise, the database performance will be affected.
    • Enabling the following parameters will affect the database performance: log_hostname, log_duration, log_connections, and log_disconnections. Exercise caution when enabling these parameters.
    • If you enable the parameter log_duration, SQL statements containing sensitive information may be recorded in logs. You are advised to disable this parameter.
    • If the parameter log_min_duration_statement is set to 0, SQL statements containing sensitive information will be recorded in logs. You are advised to disable this parameter by setting it to -1.

    Available operations are as follows:

    The modifications take effect only after you apply the parameter group to target DB instances. For details, see section Applying a Parameter Group to DB Instances.

    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.

    After the parameter values are modified, you can click View Change History to view the modification details.

    NOTE:

    For details on the description of parameter group statuses, see Parameter Group Statuses.

Modifying Parameters of a Specified DB Instance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, click the target DB instance.
  5. On the Parameters page, modify the parameters as required.

    Relevant parameters are as follows:
    • For details on parameter descriptions, visit the PostgreSQL official website.
    • If log_statement is set to ddl, mod, or all, the operations for creating and deleting database users (including passwords and other sensitive information) are recorded. This operation affects database performance. Exercise caution when setting this parameter.
    • search_path must be set to a schema sequence where schemas are separated by commas (,). Ensure that the schemas exist. Otherwise, the database performance will be affected.
    • Enabling the following parameters will affect the database performance: log_hostname, log_duration, log_connections, and log_disconnections. Exercise caution when enabling these parameters.
    • If you enable the parameter log_duration, SQL statements containing sensitive information may be recorded in logs. You are advised to disable this parameter.
    • If the parameter log_min_duration_statement is set to 0, SQL statements containing sensitive information will be recorded in logs. You are advised to disable this parameter by setting it to -1.

    Available operations are as follows:

    After you modify parameters in a parameter group, the modifications immediately take effect for the DB instance to which the parameter group applies.

    For details on the description of parameter group statuses, see Parameter Group Statuses.

    After you modify parameters in a parameter group, you need to view the status of the DB instance to which the parameter group applies. If the status is Pending reboot, you must reboot the DB instance for the modifications to take effect.
    • The modified parameter group applies to primary/standby DB instances. In this case, the standby DB instance will also be changed accordingly after the reboot.
    • The modified parameter group applies to a read replica.
    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.

    After the parameter values are modified, you can click View Change History to view the modification details.