[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