[check_postgres] Bloat check skips messages for tables with same name in different databases

Mark Kirkwood mark.kirkwood at catalyst.net.nz
Fri May 29 03:23:51 UTC 2009


I've been looking at using check_postgres.pl to check bloat - which is 
seems to do really well.

By accident I noticed that for a check which includs multiple databases, 
each containing the same schema e.g 3 copies of pgbench:

$ check_postgres.pl --port=5432 --dbname=bench,bench1,bench2 
--action=bloat --warn='10M' --critical='1G' --timeout=100

I only get 1 warning from database 'bench', when in fact all of 'em have 
bloated tables. Is this intended?

After a bit of gazing at the code I make a change that got me all the 
warnings back (attached) - hopefully I haven't completely broken the 
intent of the 'seeit' check!

Cheers

Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_postgres.pl.diff
Type: text/x-patch
Size: 750 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090529/7002ee0a/attachment.bin 


More information about the Check_postgres mailing list