X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/3ec71f5485e7f07c4ff2306d65d780951b61d71e..15c5f64e3607c5d84383af0f8a08137f3fb8a9f6:/roles/db.rb?ds=inline diff --git a/roles/db.rb b/roles/db.rb index 81aed8678..05cd66aa9 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -42,16 +42,19 @@ default_attributes( :max_connections => "1500", :max_stack_depth => "7MB", :wal_level => "logical", - :checkpoint_segments => "32", :max_wal_size => "1536MB", :checkpoint_completion_target => "0.8", - :max_wal_senders => "10", :cpu_tuple_cost => "0.1", + :jit => "off", :log_min_duration_statement => "1000", :late_authentication_rules => [ - { :address => "10.0.32.0/20" }, - { :address => "10.0.48.0/20" }, - { :address => "10.0.64.0/20" } + { :address => "10.0.48.0/20" }, # amsterdam + { :address => "10.0.64.0/20" }, # dublin + { :database => "replication", :user => "replication", :address => "10.0.0.4/32" }, # snap-02 + { :database => "replication", :user => "replication", :address => "10.0.0.10/32" }, # eddie + { :database => "replication", :user => "replication", :address => "10.0.48.49/32" }, # snap-01 + { :database => "replication", :user => "replication", :address => "10.0.48.50/32" }, # karm + { :database => "replication", :user => "replication", :address => "10.0.64.50/32" } # snap-03 ] } }