[check_postgres] Patch to run any action over all dbs
Giles Westwood
giles.westwood at semantico.com
Tue Oct 13 15:39:52 UTC 2009
Hi Greg,
Excellent work with this plugin. I may be misunderstanding the
documentation but I couldn't work out a way of running the actions over
all databases, without knowing them already.
I created an option --alldb to run the psql listing and pass the output
into the --db parameter.
I use it with bloat and autovaccum e.g
check_postgres --action last_vacuum --alldb --critical 30days --dbuser
root --port 5432
check_postgres --action bloat --alldb --dbuser root --port 5432
--
Giles Westwood, Systems Administrator,
Semantico, Floor 1, 21-23 Dyke Road, Brighton BN1 3FE
<http://www.semantico.com/>
<mailto:Giles.Westwood at semantico.com>
<tel:+44-1273-358231> <fax:+44-1273-723232>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: check_postgres_all.patch
Url: https://mail.endcrypt.com/pipermail/check_postgres/attachments/20091013/c72b79c4/attachment.pl
More information about the Check_postgres
mailing list