[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