Skip to main content
Version: 1.0.16

Other Parameters

database_compat_mode​

Enum type. Database running mode. Default value postgresql. Other available values include oracle, sybase, mysql.

#database_compat_mode = 'postgresql'    # database compat mode, values can be:
                                        # postgresql (default)
                                        # oracle
                                        # sybase
                                        # mysql
                                        # sqlserver (not support yet)
                                        # db2 (not support yet)

Halo 16 recommends using the cluster_net_services parameter instead, which supports multi-mode coexistence. See Compatibility Mode Configuration.

cluster_net_services​

String type. Halo 16 multi-mode listening configuration. Format is IP:port:mode, with multiple modes separated by commas ,.

cluster_net_services = ':5432:postgresql,:1521:oracle,:3306:mysql'

standard_parserengine_auxiliary​

Boolean type. Whether the standard parser engine collaboration is needed. Default value on.

standard_parserengine_auxiliary = on

heap_default_fillfactor​

Numeric type. Default value for FILLFACTOR on tables. Default value 100.

#heap_default_fillfactor = 100

enable_col_output_upcase​

Boolean type. Whether column name output uses uppercase. Default value false.

#enable_col_output_upcase = false

oracle.use_datetime_as_date​

Boolean type. Whether to use the DATETIME type to replace the DATE type. Only effective in Oracle mode. Default value false.

oracle.use_datetime_as_date = true

oracle.transform_null_string​

Boolean type. Converts empty strings to NULL. Only effective in Oracle mode. Default value false.

#oracle.transform_null_string = true    # only work for oracle mode

timezone​

String type. Timezone setting. Default value GMT. For China, it is recommended to set to Asia/Shanghai.

timezone = 'Asia/Shanghai'

search_path​

String type. Schema search order used when looking up objects. By default, when the running mode is postgresql, pg_catalog is the first schema searched; when the running mode is oracle, oracle is the first schema searched.

#search_path = '"$user", public'    # schema names

statement_sharing​

Enum type. Statement sharing mode, controlling the sharing and reuse strategy of SQL statement execution plans. Available values: exact (exact match), normal (share the same SQL statement execution plans to reduce parsing overhead), none (no sharing). Default value none.

#statement_sharing = 'none'                # exact
                                        # normal
                                        # none

It is recommended to use bind variables in applications and configure this parameter appropriately based on actual requirements.

sql_firewall_mode​

Enum type. SQL firewall mode. Available values: disabled (disabled), learning (learning), permissive (permissive), enforcing (enforcing). Default value disabled.

#sql_firewall_mode = 'disabled'            # disabled learning permissive enforcing

nac_transation_level​

Enum type. Transaction level control. Available values: block (block level), statement (statement level). Default value block.

nac_transation_level = block        #block, statement

_enable_backend_fault_tolerance​

Boolean type. Backend fault tolerance switch. Default value off.

_enable_backend_fault_tolerance = on