Re: mail alert - Mailing list pgsql-general

From Christophe Pettus
Subject Re: mail alert
Date
Msg-id 1899F341-F357-4CD6-8C0B-18CE87891481@thebuild.com
Whole thread Raw
In response to mail alert  (Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be>)
Responses Re: mail alert  ("Ow Mun Heng" <ow.mun.heng@wdc.com>)
List pgsql-general
On Aug 11, 2009, at 12:19 AM, Jan Verheyden wrote:
> I was looking in what way it’s possible to alert via mail when some
> conditions are true in a database.

An external script that connects to the database, checks for the
condition, and sends the email if it exists is probably your best
solution.  You might want to take a look at check_postgres:

    http://bucardo.org/check_postgres/

--
-- Christophe Pettus
    xof@thebuild.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: mail alert
Next
From: "Peter Headland"
Date:
Subject: Does PERFORM hold a lock?