Make sure cgimap uses the writable database for updates

[chef.git] / roles / bowser.rb

diff --git a/roles/bowser.rb b/roles/bowser.rb
index e15bf775f69cab26fb42dcb401ac6510f522d3fd..1ae0353930c4ceb789c0ef2ab733bc7d864a753b 100644 (file)
--- a/roles/bowser.rb
+++ b/roles/bowser.rb
@@ -2,6 +2,9 @@ name "bowser"
 description "Master role applied to bowser"
 
 default_attributes(
+  :apt => {
+    :sources => ["postgresql"]
+  },
   :location => "Carlton, Victoria, Australia",
   :networking => {
     :interfaces => {
@@ -12,7 +15,6 @@ default_attributes(
         :address => "138.44.68.106",
         :prefix => "30",
         :gateway => "138.44.68.105",
-        :mtu => 9000,
         :bond => {
           :slaves => %w[ens14f0 ens14f1]
         }
@@ -22,9 +24,43 @@ default_attributes(
       "202.158.207.1",
       "202.158.207.2"
     ]
+  },
+  :postgresql => {
+    :versions => ["10"],
+    :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 => "10/main",
+      :postgis => "2.4"
+    },
+    :node_file => "/store/database/nodes",
+    :styles => {
+      :default => {
+        :tile_directories => [
+          { :name => "/store/tiles/default", :min_zoom => 0, :max_zoom => 19 }
+        ]
+      }
+    }
   }
 )
 
 run_list(
-  "role[aarnet]"
+  "role[aarnet]",
+  "role[tile]"
 )