X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/ab863f7f6f6e537980861c533b5d8612986824f9..1a062eb5304d0ef835313e5948053fcdccf20ecf:/cookbooks/postgresql/attributes/default.rb diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 038fadeff..878407aec 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -1,5 +1,6 @@ default[:postgresql][:versions] = [] default[:postgresql][:clusters] = {} +default[:postgresql][:monitor_database] = "postgres" default[:postgresql][:settings][:defaults][:port] = "5432" default[:postgresql][:settings][:defaults][:max_connections] = "100" default[:postgresql][:settings][:defaults][:ssl] = "true" @@ -25,8 +26,10 @@ default[:postgresql][:settings][:defaults][:min_wal_size] = "80MB" default[:postgresql][:settings][:defaults][:archive_mode] = "off" default[:postgresql][:settings][:defaults][:max_wal_senders] = "10" default[:postgresql][:settings][:defaults][:max_replication_slots] = "10" +default[:postgresql][:settings][:defaults][:wal_keep_size] = "0" default[:postgresql][:settings][:defaults][:hot_standby] = "on" default[:postgresql][:settings][:defaults][:hot_standby_feedback] = "off" +default[:postgresql][:settings][:defaults][:seq_page_cost] = "1.0" default[:postgresql][:settings][:defaults][:random_page_cost] = "4.0" default[:postgresql][:settings][:defaults][:cpu_tuple_cost] = "0.01" default[:postgresql][:settings][:defaults][:effective_cache_size] = "4GB"