X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/0a610f5658389e6fa37c8c14330cbdae38b5db65..3e2102f454444729f62c5f84ea6b62370afdb62e:/roles/db.rb?ds=inline diff --git a/roles/db.rb b/roles/db.rb index 44026b0ac..670b745fd 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -6,24 +6,29 @@ default_attributes( :users => { :rails => { :status => :role, - :members => [ :tomh, :grant ] + :members => [:tomh, :grant] } } }, + :apt => { + :unattended_upgrades => { + :enable => false + } + }, :munin => { :plugins => { :postgres_connections_openstreetmap => { - :waiting => { + :waiting => { :warning => 10, :critical => 20 } }, :postgres_locks_openstreetmap => { - :accesssharelock => { + :accesssharelock => { :warning => 900, :critical => 1000 }, - :rowexclusivelock => { + :rowexclusivelock => { :warning => 250, :critical => 300 } @@ -34,7 +39,7 @@ default_attributes( "/store/rails" => { :host => "ironbelly", :path => "/store/rails" } }, :postgresql => { - :versions => [ "9.1" ], + :versions => ["9.1"], :settings => { :defaults => { :listen_addresses => "*", @@ -42,6 +47,7 @@ default_attributes( :max_stack_depth => "7MB", :checkpoint_segments => "32", :checkpoint_completion_target => "0.8", + :cpu_tuple_cost => "0.1", :late_authentication_rules => [ { :address => "146.179.159.160/27" } ]