check_postgres_last_vacuum for all databases

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: check_postgres_last_vacuum for all databases
Date: 2013-05-14 19:16:19
Message-ID: CAGoODpfzDQ8jM=+o2xJC=Cps+-kqi4LtSL9BJZSMQ9W6-NKZCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have been setting up nagios alert for check_postgres_last_vacuum.
I went through the code and saw that I have to define the databases in
order to check for all database tables. In my environment, database
creation and deletion is dynamic. So any time any one can create database
or delete for their needs.
And I configured manual vacuum process for all databases each night.

In this scenario, I was looking for a tool to check the last vacuum time in
the servers so that if any table's last vacuum date is N days older, nagios
will send an alert.

Any idea for it.

Thanks,
AI

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2013-05-14 21:09:52 Re: How to convert numbers into words in postgresql
Previous Message Paul Jungwirth 2013-05-14 17:32:41 Re: Storing Special Characters