Configure wal_level on database slaves

[chef.git] / roles / palulukon.rb

diff --git a/roles/palulukon.rb b/roles/palulukon.rb
index c1f5a1922742bc4081a486820355af4840f5e261..69183cb9eb56f66a2f736c5f5047d2e1957ab9a5 100644 (file)
--- a/roles/palulukon.rb
+++ b/roles/palulukon.rb
@@ -10,7 +10,40 @@ default_attributes(
         :family => :inet,
         :address => "172.31.37.101",
         :prefix => "20",
         :family => :inet,
         :address => "172.31.37.101",
         :prefix => "20",

-        :gateway => "172.31.32.1"
+        :gateway => "172.31.32.1",
+        :public_address => "3.144.0.72"
+      }
+    }
+  },
+  :postgresql => {
+    :settings => {
+      :defaults => {
+        :shared_buffers => "8GB",
+        :maintenance_work_mem => "7144MB",
+        :effective_cache_size => "16GB"
+      }
+    }
+  },
+  :sysctl => {
+    :postgres => {
+      :comment => "Increase shared memory for postgres",
+      :parameters => {
+        "kernel.shmmax" => 9 * 1024 * 1024 * 1024,
+        "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096
+      }
+    }
+  },
+  :tile => {
+    :database => {
+      :cluster => "14/main",
+      :postgis => "3"
+    },
+    :mapnik => "3.1",
+    :styles => {
+      :default => {
+        :tile_directories => [
+          { :name => "/store/tiles/default", :min_zoom => 0, :max_zoom => 19 }
+        ]

       }
     }
   }
       }
     }
   }


@@ -23,5 +56,6 @@ override_attributes(
 )
 
 run_list(
 )
 
 run_list(

-  "role[aws-us-east-2]"
+  "role[aws-us-east-2]",
+  "role[tile]"

 )
 )