@@ -80,30 +80,30 @@ After things go more stable we will release prebuilt packages for major platform
8080##Configuration
8181
82821 . Add these required options to the` postgresql.conf ` of each instance in the cluster.
83- ``` sh
84- # multimaster is build on top of
85- # logical replication and will not work otherwise
86-
87- # all transactions are implicitly two-phase, so that's
88- # a good idea to set this equal to max_connections*N_nodes.
89- # at least the number of nodes
90- # at least the number of nodes
91- # Each node has:
92- # N_nodes-1 receiver
93- # N_nodes-1 sender
94- # 1 mtm-sender
95- # 1 mtm-receiver
96- # Also transactions executed at neighbour nodes can cause spawn of
97- # background pool worker at our node. At max this will be equal to
98- # sum of max_connections on neighbour nodes.
99-
100-
101-
102- ' multimaster'
103- # cluster size
104- # the 1-based index of the node in the cluster
105- ' dbname=mydb host=node1.mycluster, ...'
106- # comma-separated list of connection strings to neighbour nodes.
83+ ``` sh
84+ wal_level = logical# multimaster is build on top of
85+ # logical replication and will not work otherwise
86+ max_connections = 100
87+ max_prepared_transactions = 300# all transactions are implicitly two-phase, so that's
88+ # a good idea to set this equal to max_connections*N_nodes.
89+ max_wal_senders = 10# at least the number of nodes
90+ max_replication_slots = 10# at least the number of nodes
91+ max_worker_processes = 250# Each node has:
92+ # N_nodes-1 receiver
93+ # N_nodes-1 sender
94+ # 1 mtm-sender
95+ # 1 mtm-receiver
96+ # Also transactions executed at neighbour nodes can cause spawn of
97+ # background pool worker at our node. At max this will be equal to
98+ # sum of max_connections on neighbour nodes.
99+
100+
101+
102+ shared_preload_libraries =' multimaster'
103+ multimaster.max_nodes = 3# cluster size
104+ multimaster.node_id = 1# the 1-based index of the node in the cluster
105+ multimaster.conn_strings =' dbname=mydb host=node1.mycluster, ...'
106+ # comma-separated list of connection strings to neighbour nodes.
107107```
1081082 . Allow replication in` pg_hba.conf ` .
109109