From 23c44b88c2893df2a34cffff6896e62c67ff8adc Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Sun, 22 Jan 2023 11:12:30 +0000
Subject: [PATCH] Configure wal_level on database slaves

---
 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 07dd63dd7..a107afa71 100644
--- a/roles/db-master.rb
+++ b/roles/db-master.rb
@@ -5,7 +5,6 @@ default_attributes(
   :postgresql => {
     :settings => {
       :defaults => {
-        :wal_level => "logical",
         :archive_mode => "on",
         :archive_command => "/usr/local/bin/openstreetmap-wal-g wal-push %p --walg-prevent-wal-overwrite=true",
         :max_replication_slots => "1",
diff --git a/roles/db.rb b/roles/db.rb
index 749592ce8..81aed8678 100644
--- a/roles/db.rb
+++ b/roles/db.rb
@@ -41,6 +41,7 @@ default_attributes(
         :listen_addresses => "*",
         :max_connections => "1500",
         :max_stack_depth => "7MB",
+        :wal_level => "logical",
         :checkpoint_segments => "32",
         :max_wal_size => "1536MB",
         :checkpoint_completion_target => "0.8",
-- 
2.39.5