Enable prometheus postgres exporter

diff --git a/cookbooks/postgresql/metadata.rb b/cookbooks/postgresql/metadata.rb
index 4233b15893b1455069bbc53e712119f2be49ffd3..a145daf0e1794c967b9f236f25cc213153bf422f 100644 (file)
--- a/cookbooks/postgresql/metadata.rb
+++ b/cookbooks/postgresql/metadata.rb
@@ -9,3 +9,4 @@ supports          "ubuntu"
 depends           "apt"
 depends           "munin"
 depends           "ohai"
+depends           "prometheus"

diff --git a/cookbooks/postgresql/recipes/default.rb b/cookbooks/postgresql/recipes/default.rb
index 4e5068712259a4366f4cdacd886649f0e6539f3d..b70d167140093e612afc541199bfcc1b398a0fae 100644 (file)
--- a/cookbooks/postgresql/recipes/default.rb
+++ b/cookbooks/postgresql/recipes/default.rb
@@ -19,6 +19,7 @@
 
 include_recipe "apt"
 include_recipe "munin"
+include_recipe "prometheus"
 
 package "locales-all"
 package "postgresql-common"
@@ -152,3 +153,12 @@ clusters.each do |name, details|
     conf_variables :port => details[:port]
   end
 end
+
+ports = clusters.collect do |_, details|
+  "port=#{details[:port]}"
+end
+
+prometheus_exporter "postgres" do
+  port 9187
+  environment "DATA_SOURCE_NAME" => "user=postgres host=/run/postgresql #{ports.join(',')}"
+end