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

Replicating a Parameter Template

Scenarios

You can replicate a parameter template you have created. When you have already created a parameter template and want to include most of the custom parameters and values from that template in a new parameter template, you can replicate that parameter template. You can also export the parameter template to generate a new parameter template for future use.

After a parameter template is replicated, the new template may be displayed about 5 minutes later.

Default parameter templates cannot be replicated. You can create parameter templates based on the default ones.

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 click Replicate in the Operation column.

    Alternatively, click the target DB instance on the Instance Management page. On the Parameters page, click Export to generate a new parameter template for future use.

    To ensure that your parameter templates are applicable to all types of DB instances and databases can be started normally, the values of innodb_flush_log_at_trx_commit and sync_binlog exported from primary DB instances or read replicas are 1 by default.

  5. In the displayed dialog box, configure required information and click OK.

    Figure 1 Replicating a parameter template
    • The template name must consist of 1 to 64 characters. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), underscores (_), and periods (.).
    • The description consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=

    After the parameter template is replicated, a new template is generated in the list on the Parameter Template Management page.