[collectd] [PATCH 3/5] postgresql_default.conf: Limit query "table_states" to versions >= 8.3.

Sebastian Harl sh at tokkee.org
Tue Aug 26 16:10:20 CEST 2008


The "n_live_tup" and "n_dead_tup" columns of the pg_stat_tables view were not
available before that version.

Signed-off-by: Sebastian Harl <sh at tokkee.org>
---
 src/postgresql_default.conf |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
index 9d21217..decf39f 100644
--- a/src/postgresql_default.conf
+++ b/src/postgresql_default.conf
@@ -49,6 +49,8 @@
 
 	Column pg_n_tup_g live
 	Column pg_n_tup_g dead
+
+	MinPGVersion 80300
 </Query>
 
 <Query disk_io>
-- 
1.6.0.90.g436ed

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mailman.verplant.org/pipermail/collectd/attachments/20080826/941aba03/attachment.pgp 


More information about the collectd mailing list