Database configuration parameters

When you're creating or editing a single-node or high-availability cluster, use the DB Configuration tab to specify database configuration parameters.

The database parameters listed on the DB Configuration tab are also referred to as Grand Unified Configuration (GUC) variables. See What Is a GUC Variable? for more information.

The list of parameters is populated based on the type of database you selected on the Cluster Settings tab when you created your cluster. For more information about the parameters for your database type:

• For PostgreSQL parameters, see Setting Parameters and Server Configuration in the Postgres documentation.

• For EDB Postgres Advanced Server, see Summary of configuration parameters and Configuration parameters.

• For more information on the types of values parameters accept, see Parameter Names and Values. The types apply to both PostgreSQL and EDB Postgres Advanced Server parameters.

Modifying a parameter

1. Find the parameter you want to modify using these methods:

   • Search for a specific parameter using the search field.
   • Filter the parameters that are listed by select an option in the Show only list:
     • Custom Values — Shows only parameters that changed from the default values, either in the current session or modified in a previous session and applied to the cluster.
     • Currently Edited Values — Shows only parameters that changed during the current editing session.

2. Enter the new value in the parameter value field. Your entry can be a literal value or a formula that calculates the value based on other parameters.

   Danger

   Parameters identified with a yellow exclamation point icon trigger a restart when you save your changes. The restart terminates all open connections and takes a few minutes to complete. It takes a few more seconds for the new connection to establish. During this process, you can't connect to the database.