tencent cloud

All product documents
TencentDB for PostgreSQL
DocumentationTencentDB for PostgreSQLOperation GuideParameter ManagementSetting Instance Parameters
Setting Instance Parameters
Download PDF
Last updated: 2024-01-24 11:16:51
Setting Instance Parameters
Last updated: 2024-01-24 11:16:51
Download PDF
You can view and modify certain parameters and query parameter modification logs in TencentDB for PostgreSQL console.

Notes

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.


Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon