X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/b1b9d1a24cd4ec5bc9176af4342697a739db64e7..2eeabe9b50dc30e53e2477f7cc55a45ea5912a7a:/cookbooks/postgresql/attributes/default.rb diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 91ffbea5e..c7eeecff8 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -2,6 +2,7 @@ default[:postgresql][:versions] = [] default[:postgresql][:clusters] = {} default[:postgresql][:settings][:defaults][:port] = "5432" default[:postgresql][:settings][:defaults][:max_connections] = "100" +default[:postgresql][:settings][:defaults][:ssl] = "true" default[:postgresql][:settings][:defaults][:shared_buffers] = "32MB" default[:postgresql][:settings][:defaults][:temp_buffers] = "8MB" default[:postgresql][:settings][:defaults][:work_mem] = "1MB" @@ -21,11 +22,13 @@ default[:postgresql][:settings][:defaults][:min_wal_size] = "80MB" default[:postgresql][:settings][:defaults][:checkpoint_completion_target] = "0.5" default[:postgresql][:settings][:defaults][:archive_mode] = "off" default[:postgresql][:settings][:defaults][:max_wal_senders] = "0" +default[:postgresql][:settings][:defaults][:max_replication_slots] = "0" default[:postgresql][:settings][:defaults][:hot_standby] = "off" default[:postgresql][:settings][:defaults][:hot_standby_feedback] = "off" 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] = "128MB" +default[:postgresql][:settings][:defaults][:jit] = "on" default[:postgresql][:settings][:defaults][:log_min_duration_statement] = "-1" default[:postgresql][:settings][:defaults][:track_activity_query_size] = "1024" default[:postgresql][:settings][:defaults][:autovacuum_max_workers] = "3"