# limitations under the License.
#
-include_recipe "apt"
+include_recipe "apt::postgresql"
include_recipe "munin"
include_recipe "prometheus"
mode "644"
variables :version => version, :defaults => defaults, :settings => settings
notifies :reload, "service[postgresql]"
+ only_if { ::Dir.exist?("/etc/postgresql/#{version}/main") }
end
template "/etc/postgresql/#{version}/main/pg_hba.conf" do
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]"
+ only_if { ::Dir.exist?("/etc/postgresql/#{version}/main") }
end
template "/etc/postgresql/#{version}/main/pg_ident.conf" do
mode "640"
variables :maps => settings[:user_name_maps] || defaults[:user_name_maps]
notifies :reload, "service[postgresql]"
+ only_if { ::Dir.exist?("/etc/postgresql/#{version}/main") }
end
link "/var/lib/postgresql/#{version}/main/server.crt" do
to "/etc/ssl/certs/ssl-cert-snakeoil.pem"
+ only_if { ::Dir.exist?("/var/lib/postgresql/#{version}/main") }
end
link "/var/lib/postgresql/#{version}/main/server.key" do
to "/etc/ssl/private/ssl-cert-snakeoil.key"
+ only_if { ::Dir.exist?("/var/lib/postgresql/#{version}/main") }
end
standby_mode = settings[:standby_mode] || defaults[:standby_mode]
:restore_command => restore_command,
:passwords => passwords
notifies :reload, "service[postgresql]"
+ only_if { ::Dir.exist?("/var/lib/postgresql/#{version}/main") }
end
else
template "/var/lib/postgresql/#{version}/main/recovery.conf" do
action :delete
notifies :reload, "service[postgresql]"
+ only_if { ::Dir.exist?("/var/lib/postgresql/#{version}/main") }
end
end
end
prometheus_exporter "postgres" do
port 9187
+ scrape_interval "1m"
+ scrape_timeout "1m"
user "postgres"
options "--extend.query-path=/etc/prometheus/exporters/postgres_queries.yml"
environment "DATA_SOURCE_URI" => uris.sort.uniq.first,