| 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: | Whole Thread | Raw Message | 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
| 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 |