X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/6cfcfbe0138f1b11e9a62bd8193e729126f617ee..b84127712370d0442c31dca0ec88f6a5843f63de:/roles/db.rb diff --git a/roles/db.rb b/roles/db.rb index 6fcb9bd67..c8aebed0d 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -10,6 +10,11 @@ default_attributes( } } }, + :apt => { + :unattended_upgrades => { + :enable => false + } + }, :munin => { :plugins => { :postgres_connections_openstreetmap => { @@ -38,13 +43,16 @@ default_attributes( :settings => { :defaults => { :listen_addresses => "*", - :max_connections => "500", + :max_connections => "1000", :max_stack_depth => "7MB", :checkpoint_segments => "32", + :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", :cpu_tuple_cost => "0.1", :late_authentication_rules => [ - { :address => "146.179.159.160/27" } + { :address => "146.179.159.160/27" }, + { :address => "10.0.16.0/20" }, + { :address => "10.0.32.0/20" } ] } }