From f25e41d212334682fce74da0824ac55038cab8f2 Mon Sep 17 00:00:00 2001
From: Sebastian Harl <sh@tokkee.org>
Date: Sun, 1 Feb 2009 23:42:45 +0100
Subject: [PATCH] collectd.conf: Updated the example postgresql plugin
 configuration.

---
 src/collectd.conf.in | 31 +++++++++++++++++++++++--------
 1 file changed, 23 insertions(+), 8 deletions(-)

diff --git a/src/collectd.conf.in b/src/collectd.conf.in
index 861d22c5..15ae7f7c 100644
--- a/src/collectd.conf.in
+++ b/src/collectd.conf.in
@@ -343,26 +343,41 @@ FQDNLookup   true
 
 #<Plugin postgresql>
 #	<Query magic>
-#		Query "SELECT magic, spells FROM wizard WHERE host = $1;"
+#		Statement "SELECT magic FROM wizard WHERE host = $1;"
 #		Param hostname
-#		Column gauge magic
-#		Column counter spells
+#		<Result>
+#			Type gauge
+#			InstancePrefix "magic"
+#			ValuesFrom magic
+#		</Result>
+#	</Query>
+#	<Query rt36_tickets>
+#		Statement "SELECT COUNT(type) AS count, type \
+#		                  FROM (SELECT CASE \
+#		                               WHEN resolved = 'epoch' THEN 'open' \
+#		                               ELSE 'resolved' END AS type \
+#		                               FROM tickets) type \
+#		                  GROUP BY type;"
+#		<Result>
+#			Type counter
+#			InstancePrefix "rt36_tickets"
+#			InstancesFrom "type"
+#			ValuesFrom "count"
+#		</Result>
 #	</Query>
-#
 #	<Database foo>
 #		Host "hostname"
-#		Port 5432
+#		Port "5432"
 #		User "username"
 #		Password "secret"
-#
 #		SSLMode "prefer"
 #		KRBSrvName "kerberos_service_name"
-#
 #		Query magic
 #	</Database>
-#
 #	<Database bar>
 #		Service "service_name"
+#		Query backend # predefined
+#		Query rt36_tickets
 #	</Database>
 #</Plugin>
 
-- 
2.30.2