From 991f3c996658400c3fa6610e33651de773b5504b Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Sun, 22 Jan 2023 11:07:51 +0000 Subject: [PATCH] Configure max_wal_senders on slaves to match the master --- roles/db-master.rb | 1 - roles/db.rb | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) diff --git a/roles/db-master.rb b/roles/db-master.rb index ffea0f019..07dd63dd7 100644 --- a/roles/db-master.rb +++ b/roles/db-master.rb @@ -8,7 +8,6 @@ default_attributes( :wal_level => "logical", :archive_mode => "on", :archive_command => "/usr/local/bin/openstreetmap-wal-g wal-push %p --walg-prevent-wal-overwrite=true", - :max_wal_senders => "10", :max_replication_slots => "1", :late_authentication_rules => [ { :database => "replication", :user => "replication", :address => "10.0.0.4/32" }, # snap-02 diff --git a/roles/db.rb b/roles/db.rb index 7ff450b2f..749592ce8 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -44,6 +44,7 @@ default_attributes( :checkpoint_segments => "32", :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", + :max_wal_senders => "10", :cpu_tuple_cost => "0.1", :log_min_duration_statement => "1000", :late_authentication_rules => [ -- 2.39.5