Help Center> Relational Database Service> User Guide> Working with RDS for PostgreSQL> Parameter Template Management> Resetting a Parameter Template
View PDF

Resetting a Parameter Template

Scenarios

You can reset all parameters in a custom parameter template to their default settings.

Procedure

  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. The RDS console is displayed.
  4. On the Parameter Template Management page, click Custom Templates. Locate the target parameter template and choose More > Reset in the Operation column.
  5. Click Yes.

    Figure 1 Confirming the reset
    After you reset the parameter template, you need to view the status of the DB instance to which the parameter template applies in the DB instance list. If the status is Pending reboot, you must reboot the DB instance for the reset to take effect. Rebooting is always required after resetting parameter templates under the following circumstances:
    • The DB instance type is primary/standby. In this case, the parameters of the standby DB instance will also be changed accordingly after the reboot.
    • The reset parameter template is applied to a read replica.