Configure wal_level on database slaves

diff --git a/roles/db-master.rb b/roles/db-master.rb
index 07dd63dd7730f0eb84c48e323cb0b048b0c6053d..a107afa7159e7b8d3c2834baef91199db79c59af 100644 (file)
--- 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 749592ce831d6701ca88742bec24afb59f5b87b7..81aed86787c78142e8c042c3fc2f80e5ad5ce53b 100644 (file)
--- 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",