Install postgres 15 on database servers

[chef.git] / roles / eddie.rb

diff --git a/roles/eddie.rb b/roles/eddie.rb
index 28c9092eeb48a56f5fbe526b3888ec872a81fa3d..40a105db58c15641e0516a37d7c40306dfa150c3 100644 (file)
--- a/roles/eddie.rb
+++ b/roles/eddie.rb
@@ -2,12 +2,6 @@ name "eddie"
 description "Master role applied to eddie"
 
 default_attributes(
-  :apt => {
-    :sources => ["postgresql"]
-  },
-  :db => {
-    :cluster => "9.5/main"
-  },
   :networking => {
     :interfaces => {
       :internal_ipv4 => {
@@ -25,7 +19,8 @@ default_attributes(
         :work_mem => "64MB",
         :maintenance_work_mem => "1GB",
         :effective_cache_size => "180GB",
-        :effective_io_concurrency => "256"
+        :effective_io_concurrency => "256",
+        :random_page_cost => "1.1"
       }
     }
   },
@@ -37,24 +32,10 @@ default_attributes(
         "kernel.shmall" => 66 * 1024 * 1024 * 1024 / 4096
       }
     }
-  },
-  :sysfs => {
-    :md_tune => {
-      :comment => "Enable request merging for NVMe devices",
-      :parameters => {
-        "block/nvme0n1/queue/nomerges" => "1",
-        "block/nvme1n1/queue/nomerges" => "1",
-        "block/nvme2n1/queue/nomerges" => "1",
-        "block/nvme3n1/queue/nomerges" => "1",
-        "block/nvme4n1/queue/nomerges" => "1",
-        "block/nvme5n1/queue/nomerges" => "1",
-        "block/nvme6n1/queue/nomerges" => "1"
-      }
-    }
   }
 )
 
 run_list(
   "role[ucl]",
-  "role[db-slave]"
+  "role[db-master]"
 )