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:
Functionality | Parameter Name | Default Setting |
---|---|---|
Replication | wal_level (opens in a new tab) | logical |
Replication | max_worker_processes (opens in a new tab) | 12 |
Replication | max_replication_slots (opens in a new tab) | 16 |
Replication | max_wal_senders (opens in a new tab) | 16 |
Replication | hot_standby_feedback (opens in a new tab) | on |
Replication | wal_sender_timeout (opens in a new tab) | 5s |
Replication | track_commit_timestamp (opens in a new tab) | on |
Replication | shared_preload_libraries (opens in a new tab) | 'pg_stat_statements, snowflake, spock' |
Spock | spock.conflict_resolution | last_update_wins |
Spock | spock.save_resolutions (opens in a new tab) | on |
Auto-DDL | spock.enable_ddl_replication (opens in a new tab) | on |
Auto-DDL | spock.include_ddl_repset (opens in a new tab) | on |
Auto-DDL | spock.allow_ddl_from_functions (opens in a new tab) | on |
Snowflake | snowflake.node (opens in a new tab) | node number, 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.