X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/261e7e9cd1a9882faa4ed7087b5902ebafe25988..a2fb79fc31c9038440bc7dfc28a328bf88bad901:/cookbooks/postgresql/recipes/default.rb diff --git a/cookbooks/postgresql/recipes/default.rb b/cookbooks/postgresql/recipes/default.rb index 9dfde2448..c71416350 100644 --- a/cookbooks/postgresql/recipes/default.rb +++ b/cookbooks/postgresql/recipes/default.rb @@ -19,11 +19,6 @@ package "postgresql-common" -service "postgresql" do - action [ :enable, :start ] - supports :status => true, :restart => true, :reload => true -end - node[:postgresql][:versions].each do |version| package "postgresql-#{version}" package "postgresql-client-#{version}" @@ -37,7 +32,7 @@ node[:postgresql][:versions].each do |version| source "postgresql.conf.erb" owner "postgres" group "postgres" - mode 0644 + mode 0o644 variables :version => version, :defaults => defaults, :settings => settings notifies :reload, "service[postgresql]" end @@ -46,7 +41,7 @@ node[:postgresql][:versions].each do |version| source "pg_hba.conf.erb" owner "postgres" group "postgres" - mode 0640 + mode 0o640 variables :early_rules => settings[:early_authentication_rules] || defaults[:early_authentication_rules], :late_rules => settings[:late_authentication_rules] || defaults[:late_authentication_rules] notifies :reload, "service[postgresql]" @@ -56,7 +51,7 @@ node[:postgresql][:versions].each do |version| source "pg_ident.conf.erb" owner "postgres" group "postgres" - mode 0640 + mode 0o640 variables :maps => settings[:user_name_maps] || defaults[:user_name_maps] notifies :reload, "service[postgresql]" end @@ -69,16 +64,25 @@ node[:postgresql][:versions].each do |version| to "/etc/ssl/private/ssl-cert-snakeoil.key" end - restore_command = settings[:restore_command] || defaults[:restore_command] standby_mode = settings[:standby_mode] || defaults[:standby_mode] + primary_conninfo = settings[:primary_conninfo] || defaults[:primary_conninfo] + restore_command = settings[:restore_command] || defaults[:restore_command] if restore_command || standby_mode == "on" + passwords = if primary_conninfo + data_bag_item(primary_conninfo[:passwords][:bag], + primary_conninfo[:passwords][:item]) + end + template "/var/lib/postgresql/#{version}/main/recovery.conf" do source "recovery.conf.erb" owner "postgres" group "postgres" - mode 0640 - variables :defaults => defaults, :settings => settings + mode 0o640 + variables :standby_mode => standby_mode, + :primary_conninfo => primary_conninfo, + :restore_command => restore_command, + :passwords => passwords notifies :reload, "service[postgresql]" end else @@ -89,6 +93,11 @@ node[:postgresql][:versions].each do |version| end end +service "postgresql" do + action [:enable, :start] + supports :status => true, :restart => true, :reload => true +end + ohai_plugin "postgresql" do template "ohai.rb.erb" end @@ -98,7 +107,7 @@ package "libdbd-pg-perl" clusters = node[:postgresql][:clusters] || [] -clusters.each do |name,details| +clusters.each do |name, details| suffix = name.tr("/", ":") munin_plugin "postgres_bgwriter_#{suffix}" do @@ -131,11 +140,11 @@ clusters.each do |name,details| conf_variables :port => details[:port] end - if File.exist?("/var/lib/postgresql/#{details[:version]}/main/recovery.conf") - munin_plugin "postgres_replication_#{suffix}" do - target "postgres_replication" - conf "munin.erb" - conf_variables :port => details[:port] - end + next unless File.exist?("/var/lib/postgresql/#{details[:version]}/main/recovery.conf") + + munin_plugin "postgres_replication_#{suffix}" do + target "postgres_replication" + conf "munin.erb" + conf_variables :port => details[:port] end end