On Wed, May 5, 2010 at 3:45 PM, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:
> I am connected to the default db (postgres).
>
>
>
> Does this need to be run on a per database basis?
>
>
>
AFAIK, it has to be database specific.
But again that shouldn't be hard as you can get a list from pg_database and
loop through that using this query and pass the results to something like
Nagios (or any other monitoring tool you are using) for alerts.
--
Shoaib Mir
http://shoaibmir.wordpress.com/