+
+ports = clusters.collect do |_, details|
+ "port=#{details[:port]}"
+end
+
+file "/etc/prometheus/collectors/postgres_queries.yml" do
+ action :delete
+end
+
+template "/etc/prometheus/exporters/postgres_queries.yml" do
+ source "postgres_queries.yml.erb"
+ owner "root"
+ group "root"
+ mode "644"
+end
+
+prometheus_exporter "postgres" do
+ port 9187
+ user "postgres"
+ options "--extend.query-path=/etc/prometheus/exporters/postgres_queries.yml"
+ environment "DATA_SOURCE_NAME" => "user=postgres host=/run/postgresql #{ports.join(',')}",
+ "PG_EXPORTER_EXCLUDE_DATABASES" => "postgres,template0,template1"
+ subscribes :restart, "template[/etc/prometheus/exporters/postgres_queries.yml]"
+end