To ensure instance stability, only some parameters can be modified in the console. These parameters are displayed on the Parameter Settings page.
If the modified parameter requires instance restart to take effect, the system will ask you if you wish to restart. We recommend that you do so during off-peak hours and ensure that your application has a reconnection mechanism.
Note:
Some are key parameters, modifying which may affect your use or the normal running of the instance. Therefore, exercise caution when modifying key parameters.
Modifying Parameters in the Parameter List
Modifying parameters in batches
1. Log in to the TencentDB for PostgreSQL console. In the instance list, click an Instance ID or Manage in the Operation column to access the instance management page.
2. On the Parameter Settings tab, click Batch Modify Parameters.
3. Locate the desired parameters, and modify their values in the Current Value column. After confirming that everything is correct, click Confirm Modification.
4. In the pop-up dialog box, confirm that all parameter values are correctly modified, and click OK.
Note:
If there are modified parameters requiring instance restart to take effect, click Restart Now and then the instance will be restarted. The modified parameters take effect only after the restart is completed.
Modifying one parameter
1. Log in to the TencentDB for PostgreSQL console. In the instance list, click an Instance ID or Manage in the Operation column to access the instance management page.
2. On the Parameter Settings tab, locate the desired parameter in the parameter list and click
in the Current Value column.
3. Modify the value within the restrictions stated in the Acceptable Values column and click
to save the modification. You can click
to cancel the operation.
4. In the pop-up dialog box, confirm that the parameter value is correctly modified, and click OK.
Note:
If the modified parameter requires instance restart to take effect, click Restart Now and then the instance will be restarted. The modified parameter takes effect only after the restart is completed.
Viewing Parameter Modification Logs
1. Log in to the TencentDB for PostgreSQL console. In the instance list, click an Instance ID or Manage in the Operation column to access the instance management page.
2. On the Parameter Settings tab, click Recent Modifications on the right.
3. You can view the recent parameter modification records here.
