Switch piasa to use postgresql 15

[chef.git] / cookbooks / postgresql / attributes / default.rb

diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb
index 54a224345121ac15af47adaac4d686ecdc1a3d62..878407aecf854432f264f63334c6689a7a8c074e 100644 (file)
--- a/cookbooks/postgresql/attributes/default.rb
+++ b/cookbooks/postgresql/attributes/default.rb
@@ -1,6 +1,6 @@
 default[:postgresql][:versions] = []
 default[:postgresql][:clusters] = {}
 default[:postgresql][:versions] = []
 default[:postgresql][:clusters] = {}

-default[:postgresql][:monitor_tables] = true
+default[:postgresql][:monitor_database] = "postgres"

 default[:postgresql][:settings][:defaults][:port] = "5432"
 default[:postgresql][:settings][:defaults][:max_connections] = "100"
 default[:postgresql][:settings][:defaults][:ssl] = "true"
 default[:postgresql][:settings][:defaults][:port] = "5432"
 default[:postgresql][:settings][:defaults][:max_connections] = "100"
 default[:postgresql][:settings][:defaults][:ssl] = "true"


@@ -26,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][: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][: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"
 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"