Configure Database

DBCC allows you to configure database parameters (equivalent to modifying the postgresql.conf file) and database connection authentication (equivalent to modifying the pg_hba.conf file) directly through the web interface.

Access the page

To access the Database Config page, you need to:

1. Access the DBCC dashboard in your browser via http://<cluster_node_IP>:8080/.

2. Click Database Config in the left navigation menu to enter the page.

Modify database parameters

On the Database Parameters tab, you can view and modify the database configuration parameters (GUCs).

You can search for a specific parameter by entering keywords in the “Configuration Item” search box and clicking Query.

The list displays the following information for each parameter:

Column	Description
Configuration Item	The name of the configuration parameter.
Category	The category to which the parameter belongs.
Configuration Type	The data type of the parameter value (for example, bool, integer, string).
Read-only	Indicates whether the parameter is read-only.
System Default	Indicates whether the parameter is using the system default value.
Coordinator	The current value on the Coordinator node.
Segment	The current value on the Segment nodes.
Activation Method	The method required to activate the change (for example, reload or restart).
Description	A brief description of the parameter.
Update Time	The time when the parameter was last updated.

View Parameter Details:

Click the parameter name in the Configuration Item column to view the complete information of the parameter in the slide-out panel on the right, including:

• Basic Information: Configuration item name, category, configuration type, current and recommended values for Coordinator and Segment, activation method, etc.

• Description: Detailed description of the parameter function.

• Notification: Relevant notification information.

• History: Modification history of the parameter on Coordinator and Segment nodes, including reset status, initial value, and update time.

To modify one or more parameters:

1. Select the check box next to the configuration item(s) you want to modify.

2. Click the Batch Update button in the upper right corner of the list.

3. In the Batch Update dialog box, enter the new value for the parameter(s) in the Coordinator and/or Segment input boxes.

   • If you want to reset a parameter to its default value, verify the Reset checkbox is available and select it, or manually enter the default value.

4. Click Confirm to apply the changes.

Note

Some parameter changes might require a database restart to take effect, as indicated by the Activation Method column.

Modify database authentication

On the Database Authentication tab, you can view and configure the client authentication settings (equivalent to the pg_hba.conf file). These settings control which users can connect to which databases from which hosts, and the authentication methods they must use.

View authentication rules

The list displays the current authentication rules. The columns correspond to the fields in pg_hba.conf:

Column	Description
Type	The connection type (for example, local, host, hostssl).
Database	The database name(s) to which the rule applies.
User	The database user name(s) to which the rule applies.
Address	The client machine address (for host records).
Method	The authentication method to use (for example, trust, md5, ident).
Options	Optional parameters for the authentication method.
Remark	A remark or comment for the rule.
Actions	Options to edit, delete, or toggle the rule status.

Add an authentication rule

To add a new authentication rule:

1. Click the + Create Config button.

2. A new row appears in the list. Fill in the configuration fields:

   • Type: Select the connection type (for example, host).

   • Database: Select or enter the database name.

   • User: Select or enter the user name.

   • Address: Enter the IP address range (CIDR format) if applicable.

   • Method: Select the authentication method.

   • Options: Enter any additional options if needed.

   • Remark: (Optional) Add a comment.

3. Click Save in the Actions column to save the new rule.

Modify or delete a rule

• Modify: Click the Edit icon (pencil) in the Actions column of the rule you want to change. Update the fields and click Save.

• Delete: Click the Delete icon (trash can) in the Actions column to remove a rule.

• Activate/Deactivate: Use the toggle switch in the Actions column to enable or disable a rule. INACTIVE means the rule is ignored.

Reorder rules

The order of records in pg_hba.conf is significant because the first matching record is used. You can change the order of the rules in the list by dragging the handle (the dotted icon) on the left side of each row.

Note

After making changes, ensure they are applied. Some changes might require a reload or restart depending on the system configuration.

Manage historical versions

DBCC maintains a history of your configuration changes.

1. Click the View Historical Versions at the top of the Database Authentication tab.

2. A Version List sidebar appears on the right, displaying the history of configuration versions.

3. For each version, you can perform the following actions:

   • Load To Editor: Click the Load To Editor icon to load the configuration from that version into the main editor. This allows you to revert to a previous configuration or use it as a starting base.

   • View Difference: Click the View Difference icon to compare the configuration of that version.