#
-# Cookbook Name:: postgresql
+# Cookbook:: postgresql
# Recipe:: default
#
-# Copyright 2012, OpenStreetMap Foundation
+# Copyright:: 2012, OpenStreetMap Foundation
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
-# http://www.apache.org/licenses/LICENSE-2.0
+# https://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# limitations under the License.
#
-package "postgresql-common"
+include_recipe "apt"
+include_recipe "munin"
-service "postgresql" do
- action [:enable, :start]
- supports :status => true, :restart => true, :reload => true
-end
+package "locales-all"
+package "postgresql-common"
node[:postgresql][:versions].each do |version|
package "postgresql-#{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
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]"
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
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
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