Managing a Cluster
Setting Parameter Values

Setting Parameter Values

pgEdge Platform uses parameter settings in the postgresql.conf (opens in a new tab) file to manage the replication behavior of PostgreSQL and the extensions that provide advanced functionality for pgEdge.

The parameters are set to their default values when you install pgEdge. You can modify the parameter values later, but should consider the default values to be the minimum values required; we do not recommend lowering these values:

FunctionalityParameter NameDefault Setting
Replicationwal_level (opens in a new tab)logical
Replicationmax_worker_processes (opens in a new tab)12
Replicationmax_replication_slots (opens in a new tab)16
Replicationmax_wal_senders (opens in a new tab)16
Replicationhot_standby_feedback (opens in a new tab)on
Replicationwal_sender_timeout (opens in a new tab)5s
Replicationtrack_commit_timestamp (opens in a new tab)on
Replicationshared_preload_libraries (opens in a new tab)'pg_stat_statements, snowflake, spock'
Spockspock.conflict_log_levelThe log level to use for logging conflicts; the default is: DEBUG.
Spockspock.save_resolutions (opens in a new tab)on
Auto-DDLspock.enable_ddl_replication (opens in a new tab)on
Auto-DDLspock.include_ddl_repset (opens in a new tab)on
Auto-DDLspock.allow_ddl_from_functions (opens in a new tab)on
Snowflakesnowflake.node (opens in a new tab)The snowflake node number; this is unique to each node.

Note: On a Multi-master replication system, these parameter settings should be identical on each node. Additionally, the roles created on each node should be the same.