X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c9488a40bb4266f665079d42fde918f4ae22e5dc..418848d98ef1254285289a7a78724b89d790d76e:/roles/db.rb diff --git a/roles/db.rb b/roles/db.rb index df79f702e..bb13e00c5 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -39,19 +39,21 @@ default_attributes( "/store/rails" => { :host => "ironbelly", :path => "/store/rails" } }, :postgresql => { - :versions => ["9.1"], + :versions => ["9.5"], :settings => { :defaults => { :listen_addresses => "*", - :max_connections => "600", + :max_connections => "1000", :max_stack_depth => "7MB", :checkpoint_segments => "32", + :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", :cpu_tuple_cost => "0.1", + :log_min_duration_statement => "1000", :late_authentication_rules => [ - { :address => "146.179.159.160/27" }, { :address => "10.0.16.0/20" }, - { :address => "10.0.32.0/20" } + { :address => "10.0.32.0/20" }, + { :address => "10.0.48.0/20" } ] } }