[check_postgres] Patch to run any action over all dbs

Giles Westwood giles.westwood at semantico.com
Wed Oct 14 11:03:30 UTC 2009


Giles Westwood wrote:
> 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
> 

doh! --include=~.*

-- 
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>


More information about the Check_postgres mailing list